underscore ( _ ) is a wildcard in oracle sql, so to get results of a row with a column containing a string with a literal underscore "wildcard" in it:
X_AGR_234253
you need to escape the underscore with a backslash ( \ ):
select * from my_table where my_column like 'X\_AGR%'
the underscore in an "sql select like" statement is like the regex period/full-stop wildcard ( . )
thanks to don:
http://www.dba-oracle.com/t_special_characters_like_sql_query.htm
The best place to *find* answers to programming/development questions, imo, however it's the *worst* place to *ask* questions (if your first question/comment doesn't get any up-rating/response, then u can't ask anymore questions--ridiculously unrealistic), but again, a great reference for *finding* answers.
No comments:
Post a Comment