Click here to Skip to main content
15,880,299 members
Home / Discussions / Database
   

Database

 
GeneralRe: Date time storing null values Pin
Rajiya29-Jun-07 1:59
Rajiya29-Jun-07 1:59 
GeneralRe: Date time storing null values Pin
kguinn3-Jul-07 8:06
kguinn3-Jul-07 8:06 
QuestionDateTime value problem Pin
phantanagu28-Jun-07 22:50
phantanagu28-Jun-07 22:50 
AnswerRe: DateTime value problem Pin
kubben29-Jun-07 1:57
kubben29-Jun-07 1:57 
Questioni Problem in Installing SQL7 localy Pin
Vimalsoft(Pty) Ltd28-Jun-07 22:18
professionalVimalsoft(Pty) Ltd28-Jun-07 22:18 
AnswerRe: i Problem in Installing SQL7 localy Pin
Dave Kreskowiak29-Jun-07 7:56
mveDave Kreskowiak29-Jun-07 7:56 
AnswerRe: i Problem in Installing SQL7 localy Pin
Mike Dimmick29-Jun-07 14:43
Mike Dimmick29-Jun-07 14:43 
Questionspace in-between search parameters Pin
acodman28-Jun-07 22:18
acodman28-Jun-07 22:18 
Hi all,

I need a way out of this sql server querry. I have a database wich stores username with space in-between. the porblem am having is that when I run a search query using like operator it returns no value. e.g
in my table I have a username stored their called "acod man" but i want to search by entering acod since i am using like operator I want it to locate "acod man" for me but it returns nothing

select username from tbl_names
where username like'%acod%'

I will appreciate your responses.
thanks in advance.
AnswerRe: space in-between search parameters Pin
Sgg24529-Jun-07 0:36
Sgg24529-Jun-07 0:36 
AnswerRe: space in-between search parameters Pin
Sgg24529-Jun-07 0:39
Sgg24529-Jun-07 0:39 
NewsNAKRA Pin
NAKRAINC28-Jun-07 22:10
NAKRAINC28-Jun-07 22:10 
GeneralRe: NAKRA Pin
Pete O'Hanlon28-Jun-07 22:20
mvePete O'Hanlon28-Jun-07 22:20 
GeneralRe: NAKRA Pin
kubben29-Jun-07 1:53
kubben29-Jun-07 1:53 
NewsNAKRA Pin
NAKRAINC28-Jun-07 22:09
NAKRAINC28-Jun-07 22:09 
NewsNAKRA Pin
NAKRAINC28-Jun-07 22:08
NAKRAINC28-Jun-07 22:08 
NewsNAKRA Pin
NAKRAINC28-Jun-07 22:06
NAKRAINC28-Jun-07 22:06 
Questionhow to encrypt whole Database ? Pin
hdv21228-Jun-07 21:51
hdv21228-Jun-07 21:51 
AnswerRe: how to encrypt whole Database ? Pin
originSH29-Jun-07 0:06
originSH29-Jun-07 0:06 
QuestionMerge Replication rights Pin
Sgg24528-Jun-07 20:15
Sgg24528-Jun-07 20:15 
QuestionCritical probs to display records..., Pin
Member 387988128-Jun-07 18:02
Member 387988128-Jun-07 18:02 
AnswerRe: Critical probs to display records..., Pin
Devkranth Kishore Vanja28-Jun-07 20:24
Devkranth Kishore Vanja28-Jun-07 20:24 
GeneralRe: Critical probs to display records..., Pin
Member 387988128-Jun-07 20:57
Member 387988128-Jun-07 20:57 
AnswerRe: Critical probs to display records..., Pin
Navneet Hegde29-Jun-07 3:34
Navneet Hegde29-Jun-07 3:34 
QuestionParamaterized Queries vs. Stored Procedures Pin
martin_hughes28-Jun-07 8:17
martin_hughes28-Jun-07 8:17 
AnswerRe: Paramaterized Queries vs. Stored Procedures Pin
kubben28-Jun-07 9:09
kubben28-Jun-07 9:09 

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

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