If you are looking for a space then use CONCAT_WS.

like this: select CONCAT_WS(' ',fisrtsname,lastname) as name

That will put a space between the two variables.

Cheers..

Rob

------------------------------------------------------------------------------------------------------------------------ Rob Spijkerman 27 Nazareth Avenue Senior Intranet Developer PO Box 8011 Allied Telesyn Research Christchurch Phone +64 3 339 3000 New Zealand DDI +64 3 339 9682 Email: rob....@alliedtelesyn.co.nz Fax +64 3 339 3001 web: http://www.alliedtelesyn.co.nz/

------------------------------------------------------------------------------------------------------------------------

a.m. >>> Brain lock. Please ignore my last post - like the little lad in the AFLAC ad (apols to non-USA readers), I was not "paying attention".

But are you by any chance getting error 1269 or 1270? If so, you probably need to cast the string ' ' to some other character set e.g. select concat(FileName, _utf8 ' ', FileSize) from blah where blah;

Rgds, G.

----- Original Message ----- From: Greg Quinn To: win...@lists.mysql.com Sent: Saturday, April 17, 2004 3:39 PM Subject: Adding a space in CONCAT

I am trying to add a space between two values in my CONCAT statement but nothing works...

I have tried

Select CONCAT(FileName, ' ', FileSize)

and

Select CONCAT(FileName, Char(32), FileSize)

But neither puts a space in between...

how do I do this?

Thanks Greg

------------------------------------------------------------------------------

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=grae...@charter.net