Before I report this as a problem I'd like to know if this is right

SELECT
_CurrentBalance,
CAST(_CurrentBalance AS VARCHAR(12))
FROM Banks

"_CurrentBalance" DECIMAL(19,2) DEFAULT 0 NOT NULL,

When I cast it it goes from 100.00 to 100


Roy Lambert

Roy,

<< When I cast it it goes from 100.00 to 100 >>

Yeah, unlike date/times, there's no display formatting for CAST when it comes to numeric types.  It's on the list, but I haven't added it yet.

Tim Young
Elevate Software
www.elevatesoft.com