Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2010
    Posts
    3

    Unanswered: how do retrieve data

    Dear All,

    1. I retrieve data and get resultset as attached.
    2. I need to only data on yellow hightlight.(have 13538 in filed) how i write query commnad to retrieving.

    Please help and advise.
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2007
    Posts
    15
    Hello Wping,

    Assuming that the numbers you want to retrieve are stored in a single field along with the others, try the following query:

    Select * from table1 where field6 like '%13538%'


    Hope this help


    OS

  3. #3
    Join Date
    Feb 2010
    Posts
    3
    That great!! many thanks

Posting Permissions

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