Thread: Concatination
View Single Post
  #2 (permalink)  
Old August 18th, 2004, 09:47 PM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Try this.

Code:
SELECT Concat_WS(",",Firstname,Replace(MI,NULL,'NULL'),Lastname) From Customers
OR
Code:
SELECT Concat_WS(",",Firstname,Replace(MI,NULL,''),Lastname) From Customers
_________________________
- Vijay G
Strive for Perfection
Reply With Quote