pass in a String literal, and all rows whose value the string contains
are returned.
Traditional LIKE query
select * from MyTable where MyColumn LIKE '%STR%'
The Reverse LIKE query
select * from MyTable where 'STR' LIKE ('%' + MyColumn + '%')
Would this work? I can't try it until this weekend...
Presumably, for a LIKE query, a non-indexed varchar(20) "MyColumn" value
comparison results in an entire table scan no matter what , so it
shouldn't be forcing any fundamental time to the query
Do you know though if there is anything I should be worried about?
Thanks in advance
dbk
Dov Katz
Enterprise & Client Technology
Morgan Stanley
750 7th Avenue | 34th Floor | NYC 10019
<mailto:[EMAIL PROTECTED]>
--------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
