Database

View All Threads First Prev Next

Sql server like clause rubonkumar28-Dec-12 4:44 rubonkumar 28-Dec-12 4:44  insert into rk_process (code,name,label) values ('01','lee001','aa' ) insert into rk_process (code,name,label) values ('01','lee002','aa' ) insert into rk_process (code,name,label) values ('01','lee003','aa' ) insert into rk_process (code,name,label) values ('01','leek001','aa' ) insert into rk_process (code,name,label) values ('01','leek001','aa' ) want to filter only (lee) but it showing (leek) also select name from rk_process where name like '%lee%') thanks in advance. Result VB lee001 lee002 lee003 leek001 leek001 but i need only VB lee001 lee002 lee003 Re: Sql server like clause Richard MacCutchan28-Dec-12 6:05 Richard MacCutchan 28-Dec-12 6:05  You specified in your like clause that you want any words with "lee" so that is what you get. Try "lee0" so it will not get those containing the 'k'. One of these days I'm going to think of a really clever signature. Re: Sql server like clause PIEBALDconsult28-Dec-12 6:38 PIEBALDconsult 28-Dec-12 6:38  Not tested, but off-hand... '%lee[0-9]%' or '%lee[^k]%' P.S. You didn't specify which database system you are using. And you probably don't need the leading percent sign (%) modified 28-Dec-12 12:55pm. Re: Sql server like clause Mike Meinz28-Dec-12 6:49 Mike Meinz 28-Dec-12 6:49  Tested: select name from rk_process where name like '%lee[0-9]%' Yields: lee001 lee002 lee003 Re: Sql server like clause rubonkumar28-Dec-12 19:08 rubonkumar 28-Dec-12 19:08  thank you so much PIEBALDconsult Re: Sql server like clause rajarao3044-Jan-13 0:50 rajarao304 4-Jan-13 0:50  by using this query you can achive you require output select * from rk_process where name like '%lee0%' --raj

Last Visit: 31-Dec-99 18:00     Last Update: 25-Apr-24 3:39 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.