how can i CONCAT 2 columns & () ?
SELECT CONCAT(A,B) AS C From myTAble
but I want to get A (B)
dog (red)
thank youare they both strings?
if so SELECT COALESCE(A,'') + '(' + COALESCE(B,'') + ')'|||yes string(100)
Showing posts with label red. Show all posts
Showing posts with label red. Show all posts
Tuesday, March 27, 2012
CONCAT + expression
Subscribe to:
Posts (Atom)