Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-30 : 08:51:22
|
| Yuen writes "Table name called CS<costcenter> define in (varchar)//****Before sort(in table)costcenter111333 222 3333311111 444 33333 44444//****After sortcostcenter11111111 222 22222333 33333444 44444If the DBA don't convert the data type (I don't know what his reason) to interger. How I can use SQL to sort the result like the following//**** Sort11122233344411111222223333344444Beginner SQL developer" |
|
|
|
|
|
Interger vs VarChar