what about this:
CREATE VIEW dbo.vwTblClaims_ClaimsConvert
AS
SELECT TOP 100 PERCENT CASE WHEN LEFT([Clm Spec 1], 3) = 'PBA' THEN CASE WHEN RIGHT([clm spec 1], 3) = 'swo' THEN LEFT(RIGHT([clm spec 1],
len([clm spec 1]) - 3), len([clm spec 1]) - 6) ELSE CASE WHEN RIGHT([clm spec 1], 2) = 'wo' THEN LEFT(RIGHT([clm spec 1], len([clm spec 1]) - 3),
len([clm spec 1]) - 5) ELSE CASE WHEN RIGHT([clm spec 1], 1) = 'w' THEN LEFT(RIGHT([clm spec 1], len([clm spec 1]) - 3), len([clm spec 1]) - 4)
ELSE RIGHT([clm spec 1], len([clm spec 1]) - 3) END END END ELSE CASE WHEN LEFT([Clm Spec 1], 2) = 'PB' THEN CASE WHEN RIGHT([clm spec 1],
3) = 'swo' THEN LEFT(RIGHT([clm spec 1], len([clm spec 1]) - 2), len([clm spec 1]) - 5) ELSE CASE WHEN RIGHT([clm spec 1], 2)
= 'wo' THEN LEFT(RIGHT([clm spec 1], len([clm spec 1]) - 2), len([clm spec 1]) - 4) ELSE CASE WHEN RIGHT([clm spec 1], 1)
= 'w' THEN LEFT(RIGHT([clm spec 1], len([clm spec 1]) - 2), len([clm spec 1]) - 3) ELSE RIGHT([clm spec 1], len([clm spec 1]) - 2)
END END END ELSE CASE WHEN RIGHT([clm spec 1], 3) = 'swo' THEN LEFT([clm spec 1], len([clm spec 1]) - 3) ELSE CASE WHEN RIGHT([clm spec 1],
2) = 'wo' THEN LEFT([clm spec 1], len([clm spec 1]) - 2) ELSE CASE WHEN RIGHT([clm spec 1], 1) = 'w' THEN LEFT([clm spec 1], len([clm spec 1]) - 1)
ELSE [clm spec 1] END END END END END AS controlnum, [Dlr Num], Promo, [Trans Code], [Proc Date], [Invoice Num], [Clm Date], [Amt Claimed],
[Amt Appr], [Amt Paid], [Ad From], [Ad To], Media, [Media Desc], [Audit 1], [Audit 2], [Audit 3], [Audit 4], [Audit 5], [Audit 6], [Audit 7], [Audit 8], [Audit 9],
[Audit 10], [Audit 11], [Audit 12], [Prod Code 1], [Prod Code 1 %], [Prod Code 1 Amt], [Prod Code 1 Adv Amt], [Prod Code 2], [Prod Code 2 %],
[Prod Code 2 Amt], [Prod Code 2 Adv Amt], [Prod Code 3], [Prod Code 3 %], [Prod Code 3 Amt], [Prod Code 3 Adv Amt], [Prod Code 4], [Prod Code 4 %],
[Prod Code 4 Amt], [Prod Code 4 Adv Amt], [Prod Code 5], [Prod Code 5 %], [Prod Code 5 Amt], [Prod Code 5 Adv Amt], [Prod Code 6], [Prod Code 6 %],
[Prod Code 6 Amt], [Prod Code 6 Adv Amt], [Prod Code 7], [Prod Code 7 %], [Prod Code 7 Amt], [Prod Code 7 Adv Amt], [Prod Code 8], [Prod Code 8 %],
[Prod Code 8 Amt], [Prod Code 8 Adv Amt], [Prod Code 9], [Prod Code 9 %], [Prod Code 9 Amt], [Prod Code 9 Adv Amt], [Prod Code 10], [Prod Code 10 %],
[Prod Code 10 Amt], [Prod Code 10 Adv Amt], Comment, [Received Date], [Last Modified], [Prior Appr Num], [AltPayee Flag], [AltPayee Number], Ratio,
[Number Of Ads], [Amt Applied], UM, [Audited Amt], [Rated Ads], [Branch Number], Operator, [Bal Pending], [Paid From Pending], [Store Num],
[Clm Spec 1], [Clm Spec 2], [Dept Num], [Doc Type], [Det Spec 1], [Det Spec 2], [Det Spec 3], [Det Spec 4], [Det Spec 5], [Det Spec 6], [Size Claimed],
[Size Appr], [Media Zip], Color, [Check Num], [Check Date], [Rate Appr], [Void Date], [Void Comment], Status, [Org Control Num], Locked, [Rec Num],
txtTracking, ysnLMGCR, FileNumberIn, FileNumberOut, systimestamp, FileLineNumber, [Control Num]
FROM dbo.Claims
WHERE (LEFT([Dlr Num], 7) <> '0000000') AND ([Trans Code] <> 'N') AND ([Trans Code] <> 'V') AND ([Trans Code] <> 'Q') AND ([Trans Code] <> 'T') AND
(LEFT(Promo, 2) = '05' OR
LEFT(Promo, 2) = '06')