Results 1 to 2 of 2

Thread: Select Record

  1. 09-02-2010, 06:50 PM #1
    programmer2010
    programmer2010 is offline Registered User
    Join Date
    Sep 2010
    Posts
    1

    Select Record

    I have a file with only one field.

    I want the count of records whose 7th Position is '*'. Can some one help.
    Reply With Quote Reply With Quote
  2. 09-03-2010, 08:33 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use COUNT(*) WHERE SUBSTR(field,7,1)='*' to get the count. Fill up the rest in the statement.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    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