convert string to int
From: Cindy Lee <dangreece_at_hotmail.com>
Date: Tue, 22 Jun 2004 17:34:30 GMT
Message-ID: <f23c08f9934aea55ede045a72bf59e4e_at_news.meganetnews.com>
in my query can I convert a string to int
Date: Tue, 22 Jun 2004 17:34:30 GMT
Message-ID: <f23c08f9934aea55ede045a72bf59e4e_at_news.meganetnews.com>
in my query can I convert a string to int
select convert(int,str_col) from table
I just need the order by, if there's a different way.
select str_col from table order by convert(int,str_col)
Received on Tue Jun 22 2004 - 19:34:30 CEST