I have a table with a column that is defined as varchar(30) (MS SQL Server
2005). Probably 99% of the values in the column are numeric, but the value can
also include an alpha character. Most of the values are three numeric
characters , such as 003, 058, or 792. However, the value can be any number of
characters (e.g., 0000885 or CRO549),

The values are correctly stored in the database tables with the leading 0's
intact. When I make my query and display the results in a <cfgrid> form, if
the value in the table has characters that are all numeric, the leading 0's are
stripped. Is there a way to make the display to not delete the leading 0's?

If the value in the table has at least one alpha character in it, the leading
0'sare not stripped when displayed.

http://www.coldfusionjedi.com/index....ng-zeros-issue

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/