> You can try
> select CAST(cast('0000000000000000000000004' as NUMERIC(20)) AS varchar);
noobie question:
Do multiple casts like that slow down the query (in general and not specifically
for the query above)? If not, what about if the query is complex?
thnx,
Chris
