select REPLACE(REPLACE(col, CHAR(13), ''), CHAR(10), ' ')
for eg :
OrderStatus=REPLACE(REPLACE(cast(OrderTxtStatus as varchar(500)), CHAR(13), ''), CHAR(10), ' ')
for eg :
OrderStatus=REPLACE(REPLACE(cast(OrderTxtStatus as varchar(500)), CHAR(13), ''), CHAR(10), ' ')
No comments:
Post a Comment