Thread: Concatination
View Single Post
  #1 (permalink)  
Old August 18th, 2004, 01:24 PM
BSkelding BSkelding is offline
Authorized User
Join Date: Mar 2004
Location: Maumee, OH, USA.
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default Concatination

I have a query that selects fields from the database and places a seperator between each field. For example:

SELECT Concat_WS(",",Firstname,MI,Lastname) From Customers

The problem is that if MI is blank it does not write a comma signifying that there is another field that does not contain any data. Is there a way to solve this?