Results 1 to 2 of 2

Thread: query

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2005
    Posts
    334

    query

    is it possible to right a query which counts the length size of column input or the datatype of column input

    eg select * from items
    where itemID length = 1
    or
    where itemID = 0 - 9

  2. #2
    PowerPoster BruceG's Avatar
    Join Date
    May 2000
    Location
    New Jersey (USA)
    Posts
    2,657

    Re: query

    how about:
    select * from items
    where itemID between 0 and 9
    "It's cold gin time again ..."

    Check out my website here.

Posting Permissions

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



Click Here to Expand Forum to Full Width