Use a space
select(username + ' ' + usertype) as ColumnZ from tbluser
As per your comment I think you are trying to find using
(username + ' ' + usertype) = 'avinash Admin'
Then I would suggest split the input in strings and match individual fields username and usertype. I think that would be better.