Concatination

BSkelding · August 18th, 2004, 01:24 PM

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?

happygv · August 18th, 2004, 09:47 PM

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