DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: extract a part of value from column values

  1. 03-11-2009, 06:11 AM #1
    mike08
    mike08 is offline Junior Member
    Join Date
    Feb 2009
    Posts
    7

    Question extract a part of value from column values

    Hi experts,

    I have a column 'Tracking code' contains the data like 'AE000030ROWLB',

    is it possible to extract 'AE000030' this alone from the tracking code column?

    Could you please give me a solution for this?
    Reply With Quote Reply With Quote
  2. 03-11-2009, 09:06 AM #2
    sadha@dbsupport
    sadha@dbsupport is offline Junior Member
    Join Date
    Apr 2008
    Location
    bangalore
    Posts
    25
    select substr(column_name,1,8) from table_name
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width