Results 1 to 3 of 3

Thread: How do I compare string?

  1. Nov 23rd, 2005, 02:16 PM #1
    PlayKid
    PlayKid is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2004
    Posts
    484

    How do I compare string?

    Dear all,

    How do I make a request such as list all the records from "ABC" to "DEF"?

    Thanks

    PlayKid
    Reply With Quote Reply With Quote
  2. Nov 23rd, 2005, 02:22 PM #2
    sixfeetsix
    sixfeetsix is offline
    Addicted Member
    Join Date
    Jan 2005
    Location
    Montréal
    Posts
    160

    Re: How do I compare string?

    SELECT * FROM SomeTable WHERE SomeColumn >= 'ABC' AND SomeColumn <='DEF'

    should be about right
    There are no stupid questions, but a whole bunch of dumb sayings !

    Save time on database code, try DataLG !
    Reply With Quote Reply With Quote
  3. Nov 23rd, 2005, 02:22 PM #3
    sevenhalo
    sevenhalo is offline
    Banned
    Join Date
    Nov 2005
    Posts
    2,367

    Re: How do I compare string?

    In a SQL Statement?

    Here's an example using Northwind:

    SELECT * FROM dbo.Customers WHERE CompanyName between 'LA' and 'PR'
    Last edited by sevenhalo; Nov 23rd, 2005 at 02:26 PM.
    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