These two SELECT are the same but...

[Nick Middleweek]

SELECT Name
FROM   dbo.LOH_Buildings
WHERE  Name = 'london house'


SELECT Name
FROM   dbo.LOH_Buildings
WHERE  Name LIKE 'london house'


... do they do anything different?

I'm using MSSQL 2K.

I want to provide a begins with, ends with and contains search option and
was hoping I could just append a '%' on either or both ends of the string
the user enters.

What are your thoughts?


Thanks,
Nick


---
You are currently subscribed to activeserverpages as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]