I am trying to write a query in Microsoft SQL that searches for data using using the first initial and last name...I have no idea how to concatenate these 2 columns into 1 string... Below is the basic writing of what I am trying to get at:
select fname, lname, concat(left(fname,1),lname)
from data
where concat(left(fname,1),lname) ='SSmith'
Any help would be appreciated! Thanks
Bookmarks