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
Printable View
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
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
i'm using an sql db,
well actually it's not nvarchar it's
the text, ntext and images data type are not ...
so ?
could you change it to nVarChar? isn't nText used for large text data.. like a memo data type in access?
yeah i'll try that!
this is just how it became when i upsize it from access!
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
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...Quote:
Originally posted by sebs
tx buddies,
everything is fine now :)