Here's a fun conversion that will bite you.
DECLARE @test VARCHAR(10)
SET @test = '50000'
SELECT convert(varchar(5), convert(int, @test))
You get back "50000".
Now do this:
DECLARE @test VARCHAR(10)
SET @test = '500000'
SELECT convert(varchar(5), convert(int, @test))
What do you get back? "*". Nifty.
Monday, April 7, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment