LIKE Operator

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

laurie-789651 SSCertifiable Points: 7680 More actions · Answer 1

select * from sysobjects where xtype='U' and name like '%_%'

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 2

laurie-789651 (8/14/2013)
select * from sysobjects where xtype='U' and name like '%_%'

That won't work because "_" is itself a wildcard character. Look up escape characters in Books Online.

John

laurie-789651 SSCertifiable Points: 7680 More actions · Answer 3

Good point.

How about

select * from sysobjects where xtype='U' and name like '%[_]%

or

select * from sysobjects where xtype='U' and name like '%[_][_]%

for two underlines..

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 4

That seems to work... as long as you remember to close your quotes!

By the way, sysobjects is there for backward compatibility only. You should use sys.objects, sys.tables or INFORMATION_SCHEMA.TABLES instead.

John

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 5

SSCertifiable

Points: 5507

August 14, 2013 at 1:34 am

Thanks Laurie...

it is working fine....

kapil_kk SSC-Insane Points: 21316 More actions · Answer 6

you can also try using ESCAPE -

SELECT s.name

FROM sys.objects s

WHERE

s.type= 'U'

AND s.name LIKE '%!_%' ESCAPE '!'

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/