Compare Strings

Hello,
I need to compare two strings that are in different fields,
my first step was capture one substring and capture the
result(in this case all the characters inside the string
are equal), but i cant use this because in some records
the substring is different because one of the strings have
more 4 characters.
I send you the two strings and hope that you can help me,
sorry but the two strings are very large
1st string:
(declare @.P1 bigint set @.P1=NULL exec Content_Save
@.ContentID = @.P1 output, @.ScheduleID = 663, @.ContractID = 367, @.IniDate = 'May 31 2004 5:06:04:000PM', @.EndDate
= 'May 31 2004 5:06:07:570PM', @.File = N'WAP UH
Politica_367_663_200405311706_d920a611-1552-
)
2nd string:
(declare @.P1 bigint set @.P1=0 exec Content_Save @.ContentID
= @.P1 output, @.ScheduleID = 663, @.ContractID = 367,
@.IniDate = 'May 31 2004 5:06:04:000PM', @.EndDate = 'May
31 2004 5:06:07:570PM', @.File = N'WAP UH
Politica_367_663_200405311706_d920a611-1552-40f
)
The two strings are always equal near the end of the
string
"....N'.. and the next 45 characters" but the not always
are equal at the begining.
Thanks a lot,
Best RegardsHave you checked out the PATINDEX statement ?
J
>--Original Message--
>Hello,
>I need to compare two strings that are in different
fields,
>my first step was capture one substring and capture the
>result(in this case all the characters inside the string
>are equal), but i cant use this because in some records
>the substring is different because one of the strings
have
>more 4 characters.
>I send you the two strings and hope that you can help me,
>sorry but the two strings are very large
>1st string:
>(declare @.P1 bigint set @.P1=NULL exec Content_Save
>@.ContentID = @.P1 output, @.ScheduleID = 663, @.ContractID =>367, @.IniDate = 'May 31 2004 5:06:04:000PM', @.EndDate
>= 'May 31 2004 5:06:07:570PM', @.File = N'WAP UH
>Politica_367_663_200405311706_d920a611-1552-
>)
>2nd string:
>(declare @.P1 bigint set @.P1=0 exec Content_Save
@.ContentID
>= @.P1 output, @.ScheduleID = 663, @.ContractID = 367,
>@.IniDate = 'May 31 2004 5:06:04:000PM', @.EndDate = 'May
>31 2004 5:06:07:570PM', @.File = N'WAP UH
>Politica_367_663_200405311706_d920a611-1552-40f
>)
>The two strings are always equal near the end of the
>string
>"....N'.. and the next 45 characters" but the not always
>are equal at the begining.
>Thanks a lot,
>Best Regards
>.
>|||Thanks Julie
>--Original Message--
>Have you checked out the PATINDEX statement ?
>J
>>--Original Message--
>>Hello,
>>I need to compare two strings that are in different
>fields,
>>my first step was capture one substring and capture the
>>result(in this case all the characters inside the string
>>are equal), but i cant use this because in some records
>>the substring is different because one of the strings
>have
>>more 4 characters.
>>I send you the two strings and hope that you can help me,
>>sorry but the two strings are very large
>>1st string:
>>(declare @.P1 bigint set @.P1=NULL exec Content_Save
>>@.ContentID = @.P1 output, @.ScheduleID = 663, @.ContractID
=>>367, @.IniDate = 'May 31 2004 5:06:04:000PM', @.EndDate
>>= 'May 31 2004 5:06:07:570PM', @.File = N'WAP UH
>>Politica_367_663_200405311706_d920a611-1552-
>>)
>>2nd string:
>>(declare @.P1 bigint set @.P1=0 exec Content_Save
>@.ContentID
>>= @.P1 output, @.ScheduleID = 663, @.ContractID = 367,
>>@.IniDate = 'May 31 2004 5:06:04:000PM', @.EndDate = 'May
>>31 2004 5:06:07:570PM', @.File = N'WAP UH
>>Politica_367_663_200405311706_d920a611-1552-40f
>>)
>>The two strings are always equal near the end of the
>>string
>>"....N'.. and the next 45 characters" but the not
always
>>are equal at the begining.
>>Thanks a lot,
>>Best Regards
>>.
>.
>