Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> select where for a specific pattern

select where for a specific pattern

From: LHradowy <lhradowy_at_gmail.com>
Date: 7 Jul 2006 11:15:27 -0700
Message-ID: <1152296127.224677.293310@m79g2000cwm.googlegroups.com> 





I have a column that I need to select on:
Data looks like:


01 002 120


01 002 160


01 005 120


01 002 125


01 1 00 02 1


01 2 00 02 3


01 2 03 02 3


01 042 160


01 2 06 02 3


01 202 167


etc.



I need to only pull this type of format:


## ### ###




select col1 from table1 where col1 like??



Next question:


How to update, this type of format:


## ### ###




To this type of format:


## # ## ## #
Received on Fri Jul 07 2006 - 13:15:27 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US