Try ...
LIKE 'Q\_%' ESCAPE '\';
--Jay.
Maurice Samuels <samuels_at_red.seas.upenn.edu> wrote in message
news:8arblb$oa0$1_at_netnews.upenn.edu...
> if anyone could help me on this one, i'd appreciate it:
>
> the query i want to run is:
> select object_name from user_objects where object_name like 'Q_%';
>
> and the output returns:
> QTEST
> Q_TEST
>
> i only want to see Q_TEST. what do i have to do to get sqlplus to
> literally interpret the Q_ as a Q_
>
> thanks in advance.
> samuels_at_eniac.seas.upenn.edu
Received on Thu Mar 16 2000 - 14:55:21 CST
