I just granted SELECT access to the users for the table in question and built the whole query string in the app.<BR><BR>Thanks for the help, though, everybody.

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

Is it possible to order by a substring in a returned field?I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...