>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
The function in SQL Server is not CHR but CHAR
CHAR(174)+'TOTAL'+CHAR(175)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.