mssql: problem with string concatenation.

Posted by 0plus1 on Stack Overflow See other posts from Stack Overflow or by 0plus1
Published on 2010-06-16T15:51:09Z Indexed on 2010/06/16 15:52 UTC
Read the original article Hit count: 279

Filed under:
|
|
|

I'm trying this as part of a big query:

(CONVERT(varchar(20), AZ_DTA_APP_AGE, 103) + ' ' + (CONVERT(varchar(20), AZ_DTA_APP_AGE, 108)) AS AZ_DTA_APP_AGE

why it doesn't work?

I get:

Syntax error near keyword 'AS'

Thank you

© Stack Overflow or respective owner

Related posts about sql

Related posts about query