in string

[nyzja]

Hi! Does SQL Server have an equivalent of the inStr function in Access? Basically, I need to evaluate a field if it has a specific string. For example, I need to know if there is "DDD" in the string "ERTGDDDE".

Please help. Thanks!

 

[Catadmin]

MOF, yes, there is.

There are a couple of methods. The first is

Select * from MyTable where MyField like '%DDD%'

The % sign is SQL's wildcard.

PatIndex and CharIndex can return position numbers within a string where your pattern occurs.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[Pattycake245]

select * from table where field like '%DDD%'

Tim

 

[mrdenny]

select patindex('DDD', 'ERTGDDDE')

See PATINDEX in BOL.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[vongrunt]

The closest T-SQL thing to VB-like inStr() function is CHARINDEX().

PATINDEX() works with patterns, so wildcard characters (%, _, blah) are interpreted different way.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)