Querying value with Question mark ?
I have a table with a column called POLISVNO where all the POLISVNO start with a question mark (?).
eg.
?412446355 1
?412709225 2when I run the following query
select POLISVNO from AWD_ABC380 where POLISVNO like '?412%';
it returns zero rows.
also when I run select POLISVNO from AWD_ABC380 where POLISVNO like '%?%';
it returns no rows back.
I have created a test table in another database and inserted values these values in there and when I run the queries it actually returns the values.
The only thing I can think of is my NLS_CHARACTERSET???
The thing is, it worked in the past and now all of a sudden it doesn't work. No database changes like parameters have been made on this database?