Re: [eclipselink-users] Query for a Integer/int and treat it like a Stri

[t3_chris <c.reiter@xxxxxxx>]

Hi Tom!

We've now decided to use a workaround to keep database independency.

We did the following:
We added a column to all tables which need to be searched for the integer
value which holds the integer value as varchar value. (Existing datarecords
have been updated by an SQL-Update statement).
Then we added a function to our businesslogic setter functions which update
the varchar columns when the integer gets updated.
Now it is very easy to perform the LIKE search on the varchar column.

Anyway, thanks for your help!

best regards,

chris
-- 
View this message in context: http://www.nabble.com/Query-for-a-Integer-int-and-treat-it-like-a-String-%28with-LIKE--123-%29-tp23535574p23555354.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.