Results 1 to 5 of 5

Thread: isql query

  1. #1
    Join Date
    Oct 2003
    Posts
    6

    Unanswered: isql query

    Hi experts,

    select voucherno from voucher where substr(voucherno,1,7)='1234567'

    would like to know what is equivalent sybase isql query for the above sql query?

    thanks in advance
    Krishna

  2. #2
    Join Date
    Dec 2002
    Posts
    104

    Re: isql query

    Originally posted by kodavalla
    Hi experts,

    select voucherno from voucher where substr(voucherno,1,7)='1234567'

    would like to know what is equivalent sybase isql query for the above sql query?

    thanks in advance
    Krishna
    hi!
    try this

    select voucherno
    from voucher
    where substring(voucherno,1,7)='1234567'

    --Pooja

  3. #3
    Join Date
    Oct 2003
    Posts
    6

    Re: isql query

    Thanks Pooja for your prompt response....

  4. #4
    Join Date
    Dec 2003
    Location
    china
    Posts
    21
    i think this is better
    select voucherno
    from voucher
    where voucherno like '1234567%'
    Walking .......

  5. #5
    Join Date
    Oct 2003
    Posts
    6

    a

    abdckdj kfjkdjflkd flkjdkf skdjdjfdf

Posting Permissions

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