Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Count number within a string

Author  Topic 

SQLforum
Starting Member

4 Posts

Posted - 2011-01-24 : 15:50:21
Dear All,

I am trying to create buckets using a string column. This string column contain 12 digits of number from 0-9. ex: 001211121003, 321010987642.

Here is my condition:

If the "1" show up twice in "DQ_string" then all other digits within the string must be < 1.
or
If the "2" show up 1 time then all other digits within "DQ_string" must be < 2

Please advise. Thanks!

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-01-24 : 16:03:39
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=155664
Go to Top of Page
   

- Advertisement -