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
 SQL Server Development (2000)
 Pattern Matching

Author  Topic 

Bex
Aged Yak Warrior

580 Posts

Posted - 2005-12-01 : 05:32:58
Is there a better way to do this?:

CREATE PROCEDURE [dbo].[usp_SelectSMSBundleCVF] 
(
@CycleInstance BIGINT
)
AS
SELECT
dbo.J36.AccountNo,
dbo.J36.MobileNo
FROM
dbo.J36
INNER JOIN
dbo.BundleInfo ON dbo.BundleInfo.J36ID = dbo.J36.J36ID
WHERE
(
dbo.J36.CycleInstanceID = @CycleInstance
)
AND
(
(
Services LIKE '%Ü%'
)
OR
(
Services LIKE '%Û%'
)
OR
(
Services LIKE '%Ú%'
)
OR
(
Services LIKE '%V%'
)
OR
(
Services LIKE '%S%'
)
OR
(
Services LIKE '%R%'
)
OR
(
Services LIKE '%è%'
)
OR
(
Services LIKE '%Ý%'
)
)
GO


Thankyou

Hearty head pats

Bex
Aged Yak Warrior

580 Posts

Posted - 2005-12-01 : 05:37:42
Forget that, I was being dumb!

like '%[stuffinhere]%'

Hearty head pats
Go to Top of Page
   

- Advertisement -