parse values - SQL Server Forums

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 2000 Forums

Transact-SQL (2000)

parse values

Author

Topic

hai
Yak Posting Veteran

84 Posts

Posted - 2007-07-13 : 14:54:32

The following work, but how would I reversed the select statement. Instead of return the condition, I want it to return the oppersite.

thanks:

DECLARE @TBL TABLE (CODE NVARCHAR(30))

INSERT INTO @TBL SELECT 'ACGT-DHVN-DHVN-GTRR-AGKM' UNION ALL
SELECT 'ACGT-DHBN-CHVN-YTRR-SWKM' UNION ALL
SELECT 'NCGT-DXVN-DHTN-GTAR-AGKM' UNION ALL
SELECT 'ACGT-AGKM-DHVN-GTRR-XGOM' UNION ALL
SELECT 'ACGT-DHVN-CHVN-GTRR-ABYM' UNION ALL
SELECT 'ACGT-DHVN-DHVN-GTRR-AXVC'

SELECT CODE FROM @TBL
WHERE (PATINDEX('%ACGT%',CODE) >= 1 AND PATINDEX('%XGOM%',CODE)>= 1)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-13 : 14:56:49

SELECT CODE FROM @TBL
WHERE NOT (PATINDEX('%ACGT%',CODE) >= 1 AND PATINDEX('%XGOM%',CODE)>= 1)

Peter Larsson
Helsingborg, Sweden

hai
Yak Posting Veteran

84 Posts

Posted - 2007-07-13 : 15:01:31

thanks peso...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources