Command similar to SQL BETWEEN?

Mike_HWG · 2012-06-25

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 · 2012-06-25

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 · 2012-06-26

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

Command similar to SQL BETWEEN?

Answers

Categories