SQL Server uses CHAR instead of CHR
>Hi,
>
>In my VFP data, in order to make sure that a record is always on a top of the index, I insert the value of chr(174) + 'TOTAL' + chr(175) to a field.
>
>How do I do it in SQL Stored procedure? SQL does not recognize chr(174) or chr(175).
>
>TIA
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer