Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* 07.Define Function*/
- CREATE FUNCTION ufn_IsWordComprised(@SetOfLetters VARCHAR(MAX) , @Word VARCHAR(MAX))
- RETURNS BIT
- BEGIN
- DECLARE @index INT = 1;
- DECLARE @result BIT = 1;
- WHILE(@index <= LEN(@Word))
- BEGIN
- IF(CHARINDEX(SUBSTRING(@WORD, @index, 1), @SetOfLetters, 1) = 0)
- BEGIN
- SET @result = 0;
- RETURN @result;
- END
- SET @index += 1;
- END
- RETURN @result;
- END
Advertisement
Add Comment
Please, Sign In to add comment