OK, first of all, I am quite new to Oracle, and am having trouble with a query that I could easily design under MSSQL Server 2k.
under MS SQL Server, my query would be as follows.
what would be the best method to do this under Oracle 8.1.5?
Thanks
under MS SQL Server, my query would be as follows.
Code:
select case when substr(field1,0,3)='111' then 'A', when substr(field1,0,3)='112' then 'B' else 'C' end
what would be the best method to do this under Oracle 8.1.5?
Thanks