SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Susantha Bathige / LIKE operator / Latest Posts

RE: LIKE operator

kapil_kk — Tue, 11 Dec 2012 03:08:51 GMT

good basic question of LIKE..I like it :-P

RE: LIKE operator

Deepak Jain-691547 — Wed, 10 Sep 2008 12:51:55 GMT

Try this to get the records start with "Cu_"select * from #Like_Test where Col1 Like 'Cu[_]%'

RE: LIKE operator

GilaMonster — Mon, 18 Aug 2008 01:41:13 GMT

Or[code]select * from #Like_Testwhere Col1 Like '%Cu/_%' ESCAPE '/'[/code]

RE: LIKE operator

arun.sas — Thu, 14 Aug 2008 00:14:21 GMT

Adequate and nice to learnTo get the exact resultselect * from #Like_Test where Col1 Like '%Cu[_]%'‘_’ is escape so[_] is the valuable one

RE: LIKE operator

sudhanva — Wed, 13 Aug 2008 23:08:09 GMT

create table #Like_Test( Col1 varchar(5) )insert #Like_Test values('_Cus')insert #Like_Test values('Cus_')insert #Like_Test values('C_us')insert #Like_Test values('Cus')insert #Like_Test values('Cu_s')select * from #Like_Test where Col1 Like '%Cu_%'How can we really get the row with value as "Cu_" then?(I mean the last record in the above table)Something like this doesnt works.. select * from #Like_Test where Col1 Like '%[Cu_]%'

RE: LIKE operator

Anipaul — Wed, 13 Aug 2008 11:32:28 GMT

Good Question ....:)

RE: LIKE operator

The Dixie Flatline — Wed, 13 Aug 2008 10:33:21 GMT

Good question, and a learning experience for meI missed it too, not realizing that the underscore wouldn't catch 'C_us'. The lesson learned is that underscore as a wildcard means that there MUST be some character, but % will accept the absence of a character. Proved this out by modifying your question a touch.create table #Like_Test( Col1 varchar(5) )goinsert #Like_Test values('_Cu')insert #Like_Test values('_Cus')insert #Like_Test values('Cus_')insert #Like_Test values('C_us')insert #Like_Test values('Cus')insert #Like_Test values('Cu_s')select * from #Like_Testwhere Col1 Like '%Cu_%'select * from #Like_Testwhere Col1 Like '%Cu%'select * from #Like_Testwhere Col1 Like '%C%u%'drop table #like_test

RE: LIKE operator

GSquared — Wed, 13 Aug 2008 08:08:29 GMT

You can also escape the wildcard characters with square-brackets.[code]where col like '[_]'[/code]or[code]where col like '[%]'[/code]

RE: LIKE operator

bhusank_neuronimbus — Wed, 13 Aug 2008 07:33:26 GMT

It was good question. I create confusion for underscore. I just like logical

RE: LIKE operator

jim.powers — Wed, 13 Aug 2008 06:58:41 GMT

Tricky, tricky! Good question though. I fell into the trap probably because I haven't had enough coffee yet this morning. I saw the % signs and just completely forgot about the _ as a wildcard.

RE: LIKE operator

A_A_R_T — Wed, 13 Aug 2008 04:26:14 GMT

Nice one. To be honest: what I [i]expected[/i] wasn't the right answer ;) But after testing it I knew what was :)Thanks for the lesson in wildcard characters!

RE: LIKE operator

Jochen Vleming — Wed, 13 Aug 2008 04:21:20 GMT

This one was quite simple (even for a n00b like myself :D)But a good try anyways...

RE: LIKE operator

ChiragNS — Wed, 13 Aug 2008 02:14:29 GMT

for a second i thought :w00t:.... nice question

LIKE operator

Susantha Bathige — Tue, 12 Aug 2008 23:28:07 GMT

Comments posted to this topic are about the item [B]LIKE operator[/B]