I am trying to concat follow column in sql.
select(username + ''+ usertype) as ColumnZ from tbluser
after concat these record come.
avinashAdmin
manojAdmin
raghuAdmin
anuAdmin
But i want in space will shown userfirstname and userlastname in column z field result
i want result like:
avinash Admin
manoj Admin
raghu Admin
anu Admin
Thanks.