General information
Category:
Coding, syntax & commands
>>>I am trying to create a view to take a variable that is filled with a search string and query that against a SQL table that will partially match the SQL table field. I can find the records of the search string matches the whole table field but if only a part of the search string is found in the record it returns nothing...Can anyone help here? Thanks again!
>>>
>>>Gary
>>If I understand correctly your problem may be one or both of the following
>>1) Try SET EXACT OFF
>>2) In your SELECT statement make sure that you have field=trim(variable)
>>The point being ensuring that variable is on the right side ot the "="
>>
>>Hope this helps (HTH) //:^)
>
>you can also write the WHERE clause:
>
>... where FieldName like '%&MyVar.%'
>
>This will return rows where your variable text string is anywhere in the field, not just at the beginning of the field.
Mark,
Excuse me for butting in but, will "where FieldName like '%&MyVar.%'" run faster than
"where ATC(myvar, mytable.myfield) > 0"? I am also trying to find a fast way of searching
for strings inside of a character field.
Thanks
Jerry Tovar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only