Determining length - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Determining length

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-12-04 : 08:17:24

Terri writes "I have a file which contains the names of members (first, sometimes middle initial and last names). I am trying to link to another file which has these in 3 different columns. I remember using at one point a substring and length function someone gave me to do this but I can't remember what it was and nothing seems to be working for me. Can anyone help?"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-04 : 08:23:07

select first + ' ' + middle + ' ' + last
from yourtablenamehere

Peter Larsson
Helsingborg, Sweden

X002548
Not Just a Number

15586 Posts

Posted - 2006-12-04 : 13:00:08

File? I assume you mean table

SELECT * FROM myFile1 L JOIN myFile2 R ON
L.LNAME = R.LNAME AND L.MNAME = R.MNAME AND L.FNAME = R.FNAME

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-04 : 13:34:25

DB2 analogy is

Directory - Database
File - Table

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources