Skip to Content
0
Former Member
Sep 20, 2011 at 11:23 AM

Cconcat SQL for BP address

26 Views

Dear All,

I doing BP address in one field

SELECT convert( varchar(100),T1.[Address]) ' ' convert(varchar(100),T1.[Block]) + '' + T1.City FROM CRD1 T1

Above query not working for concat BP address.

Regards

Sridhar.

Edited by: Sridharan.R on Sep 20, 2011 1:31 PM