InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 20:48:23 GMT20http://www.sqlservercentral.com/Forums/Topic955314-146-1.aspxHere are two options you could use:[code="sql"]--check for first name used as the first part of the last nameSELECT * FROM @tblWHERE LastName LIKE RTRIM(Fisrtname)+' %'-- check for a space in LastName (might produce false results, e.g. for Pietro de la Rosa ;-))SELECT * FROM @tblWHERE CHARINDEX(' ',LastName)>0[/code]Tue, 20 Jul 2010 12:30:03 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic955314-146-1.aspxyou could do a charindex check for a blank space and make sure the number returned is greater than 0. Make sure you trim your input though incase you have white space.I think you could also use like '% %' but that should probably be avoided for performance reasonsi would personally use charindex but would like to see what others sayTue, 20 Jul 2010 02:52:35 GMTAnimal Magichttp://www.sqlservercentral.com/Forums/Topic955314-146-1.aspxHello All,I looking for a very cleaver query I have a field LastName and by users mystake there are some that is having to names over that for E.g//FisrtName LastnameRafael Narezzi That is ok My problem is that I want a select to search for all users that is like thatFisrtname LastNameRafael Rafael Narezzihow could I do a select to get all users that have spaces between?ThanksTue, 20 Jul 2010 00:42:31 GMTnarezzi