Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
SET NOCOUNT ON
-- vulgar text filter start
DECLARE @S varchar(max),@Split char(1), @X xml
SELECT @S = @Message, @Split = ' '
SELECT @X = CONVERT(xml,'<root><s>' + REPLACE(@S,@Split,'</s><s>') + '</s></root>')
DECLARE @vtext int
set @vtext=(select COUNT(*) from(
SELECT [tValue] = T.c.value('.','varchar(20)'),vulgarword FROM @X.nodes('/root/s') T(c)
left join tVulgarTable on T.c.value('.','varchar(20)') =tVulgarTable.vulgarword
where t.vulgarword is not null)
--Vulgar text filter end
set @ReturnString = 0
set @ReturnString = 1
if (len(@Message)>160 and @vtext>0)
set @ReturnString = 3
if ((len(@Message)<160 or len(@Message)=160) and @ReturnString=5)
set @ReturnString = 2
INSERT INTO dbo.tableA
Open in new window
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
From novice to tech pro — start learning today.
Members can enroll in this course at no extra cost.