Click here to Skip to main content
       

Database

 
GeneralRe: SQL paging with search Pinmemberjschell7-Jan-13 10:12 
QuestionI want to ask query related to mysql Pinmembermanisharathore5-Jan-13 8:32 
AnswerRe: I want to ask query related to mysql PinmemberMycroft Holmes5-Jan-13 12:03 
Questionproblem in ado.net with access 2010 PinmemberAchilles844-Jan-13 0:20 
AnswerRe: problem in ado.net with access 2010 PinmemberMycroft Holmes4-Jan-13 14:55 
Questionhow to cast real data type in sql server 2005 PinmemberAuf Klarung2-Jan-13 23:55 
QuestionRe: how to cast real data type in sql server 2005 PinmemberEddy Vluggen4-Jan-13 23:52 
QuestionSql server like clause Pinmemberrubonkumar28-Dec-12 5: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
lee001
lee002
lee003
leek001
leek001
 
but i need only
 
lee001
lee002
lee003

AnswerRe: Sql server like clause PinmvpRichard MacCutchan28-Dec-12 7:05 
AnswerRe: Sql server like clause [modified] PinmemberPIEBALDconsult28-Dec-12 7:38 
GeneralRe: Sql server like clause PinmemberMike Meinz28-Dec-12 7:49 
GeneralRe: Sql server like clause Pinmemberrubonkumar28-Dec-12 20:08 
AnswerRe: Sql server like clause Pinmemberrajarao3044-Jan-13 1:50 
QuestionDatabase design question PinmemberDavidCrow27-Dec-12 16:22 
AnswerRe: Database design question PinmemberPIEBALDconsult27-Dec-12 16:52 
AnswerRe: Database design question Pinmemberjschell28-Dec-12 11:16 
GeneralRe: Database design question PinmemberPIEBALDconsult28-Dec-12 15:42 
GeneralRe: Database design question Pinmemberjschell30-Dec-12 9:28 
AnswerRe: Database design question PinmemberMycroft Holmes28-Dec-12 12:05 
QuestionImporting of Huge fixed width text file in sql server table Pinmemberibrahim sharief27-Dec-12 10:24 
AnswerRe: Importing of Huge fixed width text file in sql server table PinmemberPIEBALDconsult27-Dec-12 15:08 
AnswerRe: Importing of Huge fixed width text file in sql server table PinmemberDeepak Kr130-Dec-12 21:29 
AnswerRe: Importing of Huge fixed width text file in sql server table Pinmemberjschell31-Dec-12 10:14 
Questionshow Sum(Balance) as ob on Rows Header and add next rows balance in ob Pinmemberhadeed147227-Dec-12 7:52 
AnswerRe: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Pinmemberdjj5527-Dec-12 8:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

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


Advertise | Privacy | Mobile
Web01 | 2.8.141223.1 | Last Updated 21 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid