Thread: select query
View Single Post
  #2 (permalink)  
Old January 16th, 2005, 09:17 PM
jemacc jemacc is offline
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

you may want to create a UDF for this

but here is my try:

Code:
SELECT
      isnull(IDNO,'') + isnull(Passport,'')as SID 
FROM Student
ORDER BY IDNO
Jaime E. Maccou
Reply With Quote