ORDER BY what then?

[sebs]

Hello,

With SQL, how can i order an nVarChar field!

It gives me an error:

can't order by nvarchar,image field or ...

is there a way to order letters?

tx

[kleinma]

what database format are you using??? I have many SQL statements in my code that does an order by an nvarchar field.. I use sql server 2000

[sebs]

i'm using an sql db,

well actually it's not nvarchar it's

the text, ntext and images data type are not ...

so ?

[kleinma]

could you change it to nVarChar? isn't nText used for large text data.. like a memo data type in access?

[sebs]

yeah i'll try that!

this is just how it became when i upsize it from access!

[Buzby]

TEXT in SQL Server = MEMO in Access

You can't order on a MEMO field in Access, and you can't order on a TEXT field in SQL Server.

Use VarChars if you want to order by that column

[sebs]

tx buddies,

everything is fine now

[kleinma]

Originally posted by sebs
tx buddies,

everything is fine now

yeah sometimes using the upsizing wizard can be a little freaky.. I actually prefer the import table wizard that is in SQL server... works the same way.. but I think it does the job a little better... and there is more you can customize when importing data...