Concatenar en SQL

[felipe_loyolarodriguez]

Buenos Dias

Estuve Tratando las siguientes sentencia Para concatenar las fechas en una consulta, pero no me ha salido

SELECT T0.DocDate, T0.DocNum, T0.DocTotal, T0.Comments, Month(T0.DocDate) (signo)' , '(signo) Year(T0.DocDate)

FROM OINV T0

Tampoco asi

SELECT T0.DocDate, T0.DocNum, T0.DocTotal, T0.Comments, Month(T0.DocDate) (signo)' SPACE(1) '(signo) Year(T0.DocDate)

FROM OINV T0

Ni asi

SELECT T0.DocDate, T0.DocNum, T0.DocTotal, T0.Comments, Month(T0.DocDate) (Signo)' / '(Signo) Year(T0.DocDate)

FROM OINV T0

Alguien sabra como resolver esto?

Saludos

Atte.

FLR

Edited by: Floyola on Dec 10, 2010 10:32 AM

[Former Member · Accepted solution]

Buen dia

Trata esto

SELECT T0.DocDate, T0.DocNum, T0.DocTotal, T0.Comments, 
'Mes ' + convert(varchar(12),Month(T0.DocDate),101) +'  Año '+  convert(varchar(12),Year(T0.DocDate),101) as 'Fecha'
FROM OINV T0

Saludos.

[felipe_loyolarodriguez · Accepted solution]

Perfecto, gracias

Atte.

FLR