General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi - I was wondering - I am am passing variable strings to an SQL select statement like this...
>
>Select * from customers where &lcString into cursor temp
>
>I can pass specific values like lcString = "Smith" etc but what do I need to do to return all the records? lcString = * ???
lcString = "myField LIKE '%'"
The % is evaluated as a wild card only in a LIKE clause, not in a simple equality. This will work whether SET ANSI is ON or OFF.
Jay
Previous
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