Click here to Skip to main content
15,884,032 members
Home / Discussions / Database
   

Database

 
GeneralSQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip26-Oct-03 12:58
moredip26-Oct-03 12:58 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Edbert P26-Oct-03 13:14
Edbert P26-Oct-03 13:14 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip26-Oct-03 13:22
moredip26-Oct-03 13:22 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Edbert P26-Oct-03 15:15
Edbert P26-Oct-03 15:15 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Scott.Chappel27-Oct-03 1:54
Scott.Chappel27-Oct-03 1:54 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip29-Oct-03 1:20
moredip29-Oct-03 1:20 
Generalduplication !! Pin
bora3ee26-Oct-03 11:31
bora3ee26-Oct-03 11:31 
GeneralRe: duplication !! Pin
Edbert P26-Oct-03 13:31
Edbert P26-Oct-03 13:31 
As far as I know, there is no SQL function to trim the spaces in between words.
Why don't you separate the name field into FirstName and LastName? I usually separate them into FName,MName and LName.
It's easier to use that way.

If you can't modify the table, then you have to write your own function to separate and trim the name you want to insert
(i.e. 'ADAM' and 'SMITH') and produce an SQL like this to check whether it exists:
SELECT COUNT(*)
FROM tblName
WHERE name LIKE('ADAM%SMITH')
but this may not be 100% correct, as names like 'ADAM SAMUEL SMITH' will be counted too.

You may also want to create a function to trim the names and put them back together before inserting them to the database, which is safer.

QuestionADO.NET: Is it possible to create a dataset out of a view? Pin
Rakesh Rajan26-Oct-03 1:15
Rakesh Rajan26-Oct-03 1:15 
QuestionHow to return a boolean value from a Stored Procedure? Pin
sacoskun25-Oct-03 3:38
sacoskun25-Oct-03 3:38 
AnswerRe: How to return a boolean value from a Stored Procedure? Pin
Paul Watson25-Oct-03 4:28
sitebuilderPaul Watson25-Oct-03 4:28 
QuestionWhy the connection is so slow? Pin
yyf24-Oct-03 8:46
yyf24-Oct-03 8:46 
AnswerRe: Why the connection is so slow? Pin
Paul Watson25-Oct-03 4:31
sitebuilderPaul Watson25-Oct-03 4:31 
AnswerRe: Why the connection is so slow? Pin
Rob Graham25-Oct-03 5:36
Rob Graham25-Oct-03 5:36 
AnswerRe: Why the connection is so slow? Pin
Mike Dimmick28-Oct-03 3:12
Mike Dimmick28-Oct-03 3:12 
GeneralQuery Pin
Anonymous24-Oct-03 3:08
Anonymous24-Oct-03 3:08 
GeneralRe: Query Pin
Rocky Moore25-Oct-03 4:34
Rocky Moore25-Oct-03 4:34 
GeneralRestore Pin
Anonymous22-Oct-03 9:32
Anonymous22-Oct-03 9:32 
GeneralRe: Restore Pin
Terry O'Nolley25-Oct-03 15:02
Terry O'Nolley25-Oct-03 15:02 
GeneralCreate an text field in Access from SQL Pin
Jerome Conus22-Oct-03 3:55
Jerome Conus22-Oct-03 3:55 
GeneralRe: Create an text field in Access from SQL Pin
cyphermox22-Oct-03 12:34
cyphermox22-Oct-03 12:34 
GeneralRe: Create an text field in Access from SQL Pin
Jerome Conus22-Oct-03 19:22
Jerome Conus22-Oct-03 19:22 
GeneralRe: Create an text field in Access from SQL Pin
Chris Meech23-Oct-03 6:18
Chris Meech23-Oct-03 6:18 
GeneralRe: Create an text field in Access from SQL Pin
Jerome Conus23-Oct-03 19:51
Jerome Conus23-Oct-03 19:51 
GeneralRe: Create an text field in Access from SQL Pin
Chris Meech24-Oct-03 2:02
Chris Meech24-Oct-03 2:02 

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.