Viewing post 1 (of 1 total)
Pls Use this it will solve yr problem
ISNULL(CAST (surname AS VARCHAR) COLLATE SQL_Latin1_General_CP1_CI_AS,'')
November 20, 2008 at 6:33 am
#901006