General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>select * from q:\qa\qdms2000\qdms!document where l_cSearchtext $ title into cursor temp
I know it might seem obvious/trivial but...
WHERE alltrim(upper(l_cSeachtext))$allt(upper(l_cSearchtext))
would cover mixed cases of text. (also, the use of the IN clause might be more effective, but i've never used it - only read about it here on UT)
also for the users' sake:
ORDER by title
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