A Gentle Introduction to

SQL

NEW.

These questions have been submitted by users.



I want to sort on part of a field. Can I? What syntax?
I want to sort on part of the a field if possible. e.g. I want to sort on the STARTDTE data ( 44 for 10) in a field an example of which contains the whole of the following: PAYID='PP' AND PAYCDE='PENS' AND STARTDTE='01-12-2002 00:00:00' Is this possible and if so what's the syntax?
oracle variations:
None

access
db2
mysql
oracle
postgres
sqlserver