Find caracters in a field with long type

[Cantor]

Hi,

What I know:
If you want to find all records of the table PERSONS where the FIRSTNAME begins with 'Joh' (FIRSTNAME is a VARCHAR2 type column), you do that:
SELECT * FROM PERSONS WHERE FIRSTNAME LIKE 'Joh%';

What I ask:
How do you do that if the column is defined LONG type instead of VARCHAR2? Is it possible to do that?

Thanks

 

[JamesLean]

Yes, use the exact same syntax. eg:

SELECT * FROM tablename
WHERE col1 LIKE '100%'

Returns 100, 100342, 1002, 100999999 etc.. --James

 

[Cantor]

Obviously, I try it before to post my question.
When I use this syntax (the same as you), I have a inconsistent datatypes error (ORA-00932).

The only solution I see is to write a PL/SQL program.
I'm trying this way.

Thanks

 

[JamesLean]

My query worked in SQL Server. I don't know about Oracle but I would imagine you should be able to utilise the equivalent to SQL Server's CONVERT() function to convert the numeric into a char type and test that.

I suggest you post your question in the Oracle forum and see what they say. --James