SELECT RTRIM(First_Name) +' '+ LTRIM(Last_Name)
FROM tbl_User_Master
where userid='51403607'
o/p
--ANURAG NAYAK
SELECT RTRIM(First_Name) +SPACE(1) + LTRIM(Last_Name)
FROM tbl_User_Master
where userid='51403607'
o/p
--ANURAG NAYAK
Hello, my name is Jack Sparrow. I'm a 50 year old self-employed Pirate from the Caribbean.
No comments:
Post a Comment