loaded a table ? how it works?

[Anonymous]

here  @12:n is field in one table  and after loading the table i am  writing condition like this

where index (@12:n,'\gmaop')<1 or    index (@12:n,'*_new_yesuse*') <>1

[#2 · Accepted solution]

index function tells the position of substring.

index (@12:n,'\gmaop')<1 or    index (@12:n,'*_new_yesuse*') <>1

index (@12:n,'\gmaop')<1 :

this condition will return the records if field @12:n contains value'\gmaop' at first place means all records starting with value'\gmaop'

   index (@12:n,'*_new_yesuse*') <>1

this condition will return records which are not started with value '*_new_yesuse*'.

[#3]

Sorry first condition result  should

index (@12:n,'\gmaop')<1 :

this condition will return the records if field @12:n contains value'\gmaop' at first place means all records starting with value'\gmaop' -- this one wrong

this condition will return records which do not contain value '\gmaop'.

[Anonymous]

ok

[Anonymous]

Pls explain me with proper answer  once again i am confused?