General information
Forum:
Microsoft SQL Server
Thanks for your help
>(2) When using "$" in VFP, you can have
> (a) MYFIELDNAME $ MYSTRING or
> (b) MYSTRING $ MYFIELDNAME.
> Can the the LIKE command in SQL Server achieve the same results as above ?
You can but it could be slow on big tables.
... MYFIELDNAME Like ('%' + MYSTRING + '%') Or
MYSTRING Like ( '%' + MYFIELDNAME + '%')
Is there a faster way to achieve the same result on big tables ? Is charindex faster.
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