Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- STREET STREETNAME
- ----------- -----------------
- ORANGE ORANGE BLOSSOM
- MAIN 324-A MAIN STREET
- ORANGE
- MAIN
- declare @mytable table
- (
- id int,
- word1 varchar(100),
- word2 varchar(100),
- word1word2 varchar(100)
- )
- update @mytable
- set
- word1word2 = f.word1word2
- from
- (
- select
- id,
- dbo.match(cola, colb) word1word2
- from @tablename
- ) f
- where
- [@mytable].id = f.id
- select
- id,
- dbo.match(cola, colb) word1word2
- from @tablename
- create function match
- (
- @word1 varchar(100),
- @word2 varchar(100)
- )
- returns varchar(100)
- as
- begin
- declare
- @match varchar(100) = '',
- @i int = 1
- while @i <= len(@word1) and @i <= len(@word2)
- begin
- if substring(@word1, @i, 1) = substring(@word2, @i, 1)
- begin
- set @match = @match + substring(@word1, @i, 1)
- end
- else
- begin
- break
- end
- set @i = @i + 1
- end
- return rtrim(@match)
- end
- select dbo.match('my first', 'my second')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement