Sql against oracle db

Hi
I am executing an sql command against an Oracle Db...
My sql statement goes like this:

"SELECT QTY_REQ,QTY_COMMIT,INS_REQ,INS_COMMIT FROM Demand where left(PART_NUM,3)='"&x&"'"

but there is an error saying invalid column name...
Is it the left(PART_NUM,3)='"&x&"' cannot be use in the oracle cos i noe MS access can be use...

If tat's the prob.. Can anyone help mi to change it so tat ir can be use in the oracle db.. Thanx..

in Oracle theres a SUBSTR() function if I recalll correctly. Go find some oracle reference docs and try looking it up.

in Oracle theres a SUBSTR() function if I recalll correctly. Go find some oracle reference docs and try looking it up.

Ya it's correct.. Thanx...