Use a space
select(username + ' ' + usertype) as ColumnZ from tbluser
[EDIT]
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.
[END EDIT]