Nick,

       Try using the following query in SQL



example :



select * from users where RTRIM(LTRIM(FName))+' '+RTRIM(LTRIM(LName))='Nick Kershaw'



This should solve your problem.U can also use the UCASE() function to be doubly sure about the results.



all the best,

Dennis.