Command similar to SQL BETWEEN?

Mike_HWG

Is there syntax in NAV that operates similar to a SQL BETWEEN? Looking to do something like this:

IF mynumber BETWEEN 1 AND 10 THEN
DoStuff;


I thought I was able to do this before somehow using periods...

Mike_HWG

OK I answered my question:

IF mynumber IN [0..10] THEN
DoStuff;


However, I have a new question. Say I have the code below:


mytext := '5';
IF mytext IN THEN
DoStuff;


Is this a reliable way to do things, or do I need to cast the text into an integer?

kine

Do not forget that strings are sorted in different way than numbers. It is safer to evaluate the value into integer and than compare...