ive got a table and contains a surname text field. Why cant i do a select statement ORDER BY surname. I get an error saying i cant sort a text field! how do i go around it!
thanksYou do ANSI SQL ALTER Table and change text to Varchar 40 because text cannot be used for things like name that can be covered with Varchar 40 or 50 at most. Then do ORDER BY. Hope this helps.|||
Your surname filed is a text datatype field which cannot be sorted.
You need change this field to varchar(50) or nvarchar(50) data type to allow you sort on it.
Limno
No comments:
Post a Comment