Database

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

09-30-2016
06:51 AM

09-30-2016
06:51 AM

This is my data and I need to prove that the letter 'T' occurs more than once in the following field Type_of_Account: (there are 1000's of accounts) and i either want to put this in the Where clause, such as (Where 'T' occurs >Once). I dont want a return where T occurs only once (like Row number 3).

Type_of_Account:

T-T-V-V

T-T-V

T-V

T-T-T-V

T-T-T-T-T-T-T

Solved! Go to Solution.

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

09-30-2016
07:03 AM

1 ACCEPTED SOLUTION

3 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

09-30-2016
07:03 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

09-30-2016
07:13 AM

09-30-2016
07:13 AM

Re: need to count more than one instance of a letter in 1000's of 'hyphened' strings

where Type_of_Account not like '%T%T%'

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

09-30-2016
07:19 AM

09-30-2016
07:19 AM

Re: need to count more than one instance of a letter in 1000's of 'hyphened' strings

thanks so much