querying a comments field

[ad602000]

Hi all I have inherited a query with which i am attempting to query a comments field. The following line looks at the field but i am getting a nil return and I know that there are words containing the letter between the wildcards. i am using sqlbase 7.5.1. here is the line of code

and @upper (@scan(tr.comments,200)) like '%prod%'


any help would be appreciated
pete

 

[dickiebird]

Any values in tr.comments that might have contained prod
have been set to uppercase by your statement.
You need;
and @upper (@scan(tr.comments,200)) like '%PROD%'

HTH



Dickie Bird (-)))