I want to Check whether Customer No. Start with 'e' ..

divyesh10

I am new to navision and i want to know to Check whether Customer No. Start with 'e' ..
i tried i but not getting

mohana_cse06

Welcome to Mibuso

Can you tell us what did you try?
Did you check STRPOS function?
http://msdn.microsoft.com/en-us/library/dd355417.aspx

divyesh10

i want to select those customer No which are starting from 'E' from the customer table lookup so how can i do that?
so i have to code like if customer no stat from 'e' then.....

divyesh10

Sir I think STRPOS will return Position But i want to search particular letter

Administrator

[Topic moved from 'NAV Courses, Exams & Certification' to 'NAV/Navision Classic Client' forum]

mohana_cse06

If you get position 1 means you have Customer No. starting with e?

MBerger

Depending on how you exactly want to do it, and i am assuming you want to check case-insensitive :

Check the the first character of a variable:

UPPERCASE(Copystr(Value,1,1)) = 'E'

or

uppercase(Value[1]) = 'E'

If you want to filter your table on it :

setfilter("No.",'@%1*','E') ;

divyesh10

Thank you Very much Sir I got it ....

divyesh10

i did
IF STRPOS(Cust."No.",'E')=1 then Begin

and i got it

divyesh10

I have a bug . this E should not be case sensitive what should i do?

MBerger

i gave you several ways, all case-insensitive...you should be able to derive from those what you need.

divyesh10

Yes Sir i got that thanks alot for your kind Reply