MSSQL server where clause

[John M. Sturgess]

Sorry I did mean a quote, picked up a cold from my grandson.Thinking
somewhat slowly today.
Thanks
John

-----Original Message-----
From: omnisdev-en-bounces at lists.omnis-dev.com
[mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of John M.
Sturgess
Sent: Tuesday, November 22, 2011 10:10 AM
To: omnisdev-en at lists.omnis-dev.com
Subject: MSSQL server where clause

Anyone know how to build a where clause to locate a character variable that
contains a comma.

 

Where VCOMPANY like 'BJ'S%'

 

For this particular search I don't want to use:

Calculate VCOMPANY as "BJ'S%"

Select VCOMPANY from Company where VCOMPANY like @[VCOMPANY]

 

Thanks

John

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com