Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 max length of colum varchar max

Author  Topic 

AdiI
Starting Member

31 Posts
Posted - 2009-08-20 : 07:14:59
hello i have been facing a problem. i'm using sql server 2005. i have a column whose data type is varchar max and i have store a expression in this column which is greater 8000 character. my problem is when i insert to another place it take value up to 8000 character and ignore rest of character. plz help what is the problem
i have read the following but not get any help

http://www.teratrax.com/articles/varchar_max.html

adeel

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2009-08-20 : 07:20:30
A varchar(max) column can hold about 2 billion characters.
When you changed the datatype to varchar(max), did you also change your application that stored the values in the database?
And did you change your application to varchar(max) where you fetch the data from the database?


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

AdiI
Starting Member

31 Posts
Posted - 2009-08-20 : 07:30:54

create table bug

(val varchar(max))



INSERT INTO [dbo].[bug]

VALUES

(

'if DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'NO SALE' + char(39) + ' then 1 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'ACC_PAY' + char(39) + ' then 5 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'MONEY MOVE' + char(39) + ' then 80 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'STOCK MOVE' + char(39) + ' then 82 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'STOCK TRANSFER' + char(39) + ' then 83 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'NON MERCHANDISE' + char(39) + ' then 95 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'HEADER' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Txn_Void_Flag?=' + char(39) + 'Y' + char(39) + ' then 91 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'HEADER' + char(39) + ' then 96 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'SESSION' + char(39) + ' then 94 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'TXN PRICE CHANGE' + char(39) + ' then 74 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'PRICE CHANGE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Over_Flag?=' + char(39) + 'Y' + char(39) + ' then 71 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'PRICE CHANGE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Promotion_Flag? =' + char(39) + 'Y' + char(39) + ' then 73 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'PRICE CHANGE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Disc_Flag? =' + char(39) + 'Y' + char(39) + ' then 72 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'ITEM' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Item_Sale_Flag?=' + char(39) + 'Y' + char(39) + ' then 10 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'ITEM' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Item_Refund_Flag?=' + char(39) + 'Y' + char(39) + ' then 12 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'TENDER' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1UPPER(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)!=' + char(39) + 'CASH' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?=0 DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Change?!=0 DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1NVL( DF42E762-F9EA-42d1-8A3E-1A84A01524E1to_number( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq? ) , 0 ) !=0 then 19 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name?) =' + char(39) + 'tender' + char(39) + 'DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'UNKNOWN' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 20 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + 'DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CASH' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 21 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CARD' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 22 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CHEQUE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 23 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name?) =' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'VOUCHER' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 24 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'COUPON' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 25 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CREDIT NOTE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 26 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'GIFT CARD' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 27 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'NO CHARGE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 28 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq? DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'HOST STORE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 29 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'ZURICH ACCT' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 30 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'UNKNOWN' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 40 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CASH' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 41 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CARD' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 42 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CHEQUE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 43 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'VOUCHER' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 44 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'COUPON' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 45 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CREDIT NOTE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 46 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'GIFT CARD' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 47 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'NO CHARGE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 48 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'HOST STORE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 49 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'ZURICH ACCT' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 50 else 0 end'



)


adeel
Go to Top of Page

amrosalah
Starting Member

6 Posts
Posted - 2009-08-20 : 07:35:15
varchar(max) should allow 2 gega of text , there has to be some limitation in your stored procedure .

http://www.freesqltools.info
Go to Top of Page

AdiI
Starting Member

31 Posts
Posted - 2009-08-20 : 07:39:42
now when i select * from bug the result show in result set 8000 character not whole value that we insert now it is the problem of select
or insert either insert store full value or if it store all then why it show up to 8000 character.

adeel
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2009-08-20 : 07:42:54
You have to change the number of characters to display in

Menus -> Tools -> Options

SELECT DATALENGTH(val), val from bug

N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

AdiI
Starting Member

31 Posts
Posted - 2009-08-20 : 07:46:49
plz tell how can i find that full value save in this column becoz when i select this it show 8000 character. i think it store all character but management studio result set pane not able to show character more than 80000. i set tool >option > qurey Result > sql server > result to grid or result to text. both show 8000 character. my expression is 23000 character long if it store fully how can i check this plz help ?

adeel
Go to Top of Page

AdiI
Starting Member

31 Posts
Posted - 2009-08-20 : 07:49:02
it is 8000 how can i change it up to 25000 or more plz any command i have set from tool option but fail

adeel
Go to Top of Page

AdiI
Starting Member

31 Posts
Posted - 2009-08-20 : 07:54:42
sir i'm very thanks full for your help plz just tell me how to increase from 8000 to 25000 or more. my problem will fix plz i tried from tool but set xml unlimited but again run qurey length remain 8000 how to change this one

adeel
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2009-08-20 : 07:54:48
That's one reason.

The other reason is due to a bug in SQL Server. Try this suggestion.
Both inserts are EXACTLY the same, but the second uses double single quote instead of concatenatin the strings.
DECLARE	@Bug TABLE
	(
		Val VARCHAR(MAX)
	)

INSERT	@Bug
	(
		Val
	)

SELECT 'if DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'NO SALE' + char(39) + ' then 1 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'ACC_PAY' + char(39) + ' then 5 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'MONEY MOVE' + char(39) + ' then 80 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'STOCK MOVE' + char(39) + ' then 82 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'STOCK TRANSFER' + char(39) + ' then 83 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'NON MERCHANDISE' + char(39) + ' then 95 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'HEADER' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Txn_Void_Flag?=' + char(39) + 'Y' + char(39) + ' then 91 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'HEADER' + char(39) + ' then 96 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'SESSION' + char(39) + ' then 94 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'TXN PRICE CHANGE' + char(39) + ' then 74 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'PRICE CHANGE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Over_Flag?=' + char(39) + 'Y' + char(39) + ' then 71 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'PRICE CHANGE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Promotion_Flag? =' + char(39) + 'Y' + char(39) + ' then 73 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' + char(39) + 'PRICE CHANGE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Disc_Flag? =' + char(39) + 'Y' + char(39) + ' then 72 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'ITEM' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Item_Sale_Flag?=' + char(39) + 'Y' + char(39) + ' then 10 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'ITEM' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Item_Refund_Flag?=' + char(39) + 'Y' + char(39) + ' then 12 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'TENDER' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1UPPER(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)!=' + char(39) + 'CASH' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?=0 DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Change?!=0 DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1NVL( DF42E762-F9EA-42d1-8A3E-1A84A01524E1to_number( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq? ) , 0 ) !=0 then 19 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name?) =' + char(39) + 'tender' + char(39) + 'DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'UNKNOWN' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 20 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + 'DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CASH' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 21 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CARD' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 22 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CHEQUE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 23 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name?) =' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'VOUCHER' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 24 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'COUPON' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 25 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CREDIT NOTE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 26 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'GIFT CARD' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 27 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'NO CHARGE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 28 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq? DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'HOST STORE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 29 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'ZURICH ACCT' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 30 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'UNKNOWN' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 40 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CASH' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 41 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CARD' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 42 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CHEQUE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 43 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'VOUCHER' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 44 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'COUPON' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 45 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'CREDIT NOTE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 46 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'GIFT CARD' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 47 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'NO CHARGE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 48 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'HOST STORE' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 49 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' + char(39) + 'tender' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' + char(39) + 'ZURICH ACCT' + char(39) + ' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 50 else 0 end' UNION ALL
SELECT CAST('if DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('NO SALE' AS VARCHAR(MAX)) + char(39) + CAST(' then 1 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('ACC_PAY' AS VARCHAR(MAX)) + char(39) + CAST(' then 5 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('MONEY MOVE' AS VARCHAR(MAX)) + char(39) + CAST(' then 80 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('STOCK MOVE' AS VARCHAR(MAX)) + char(39) + CAST(' then 82 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('STOCK TRANSFER' AS VARCHAR(MAX)) + char(39) + CAST(' then 83 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('NON MERCHANDISE' AS VARCHAR(MAX)) + char(39) + CAST(' then 95 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('HEADER' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Txn_Void_Flag?=' AS VARCHAR(MAX)) + char(39) + CAST('Y' AS VARCHAR(MAX)) + char(39) + CAST(' then 91 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('HEADER' AS VARCHAR(MAX)) + char(39) + CAST(' then 96 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('SESSION' AS VARCHAR(MAX)) + char(39) + CAST(' then 94 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('TXN PRICE CHANGE' AS VARCHAR(MAX)) + char(39) + CAST(' then 74 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('PRICE CHANGE' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Over_Flag?=' AS VARCHAR(MAX)) + char(39) + CAST('Y' AS VARCHAR(MAX)) + char(39) + CAST(' then 71 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('PRICE CHANGE' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Promotion_Flag? =' AS VARCHAR(MAX)) + char(39) + CAST('Y' AS VARCHAR(MAX)) + char(39) + CAST(' then 73 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ' AS VARCHAR(MAX)) + char(39) + CAST('PRICE CHANGE' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Disc_Flag? =' AS VARCHAR(MAX)) + char(39) + CAST('Y' AS VARCHAR(MAX)) + char(39) + CAST(' then 72 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('ITEM' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Item_Sale_Flag?=' AS VARCHAR(MAX)) + char(39) + CAST('Y' AS VARCHAR(MAX)) + char(39) + CAST(' then 10 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('ITEM' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Item_Refund_Flag?=' AS VARCHAR(MAX)) + char(39) + CAST('Y' AS VARCHAR(MAX)) + char(39) + CAST(' then 12 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('TENDER' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1UPPER(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)!=' AS VARCHAR(MAX)) + char(39) + CAST('CASH' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?=0 DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Change?!=0 DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1NVL( DF42E762-F9EA-42d1-8A3E-1A84A01524E1to_number( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq? ) , 0 ) !=0 then 19 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name?) =' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST('DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('UNKNOWN' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 20 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST('DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('CASH' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 21 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('CARD' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 22 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('CHEQUE' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 23 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name?) =' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('VOUCHER' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 24 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('COUPON' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 25 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('CREDIT NOTE' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 26 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('GIFT CARD' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 27 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('NO CHARGE' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 28 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq? DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('HOST STORE' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 29 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('ZURICH ACCT' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 30 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('UNKNOWN' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 40 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('CASH' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 41 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('CARD' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 42 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('CHEQUE' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 43 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('VOUCHER' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 44 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('COUPON' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 45 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('CREDIT NOTE' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 46 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('GIFT CARD' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 47 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('NO CHARGE' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 48 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('HOST STORE' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 49 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=' AS VARCHAR(MAX)) + char(39) + CAST('tender' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=' AS VARCHAR(MAX)) + char(39) + CAST('ZURICH ACCT' AS VARCHAR(MAX)) + char(39) + CAST(' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 50 else 0 end' AS VARCHAR(MAX)) UNION ALL
SELECT 'if DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''NO SALE'' then 1 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''ACC_PAY'' then 5 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''MONEY MOVE'' then 80 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''STOCK MOVE'' then 82 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''STOCK TRANSFER'' then 83 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''NON MERCHANDISE'' then 95 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''HEADER'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Txn_Void_Flag?=''Y'' then 91 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''HEADER'' then 96 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''SESSION'' then 94 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''TXN PRICE CHANGE'' then 74 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''PRICE CHANGE'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Over_Flag?=''Y'' then 71 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''PRICE CHANGE'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Promotion_Flag? =''Y'' then 73 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )= ''PRICE CHANGE'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Acc_Item_Disc_Flag? =''Y'' then 72 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''ITEM'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Item_Sale_Flag?=''Y'' then 10 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''ITEM'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Item_Refund_Flag?=''Y'' then 12 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''TENDER'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1UPPER(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)!=''CASH'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?=0 DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Change?!=0 DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1NVL( DF42E762-F9EA-42d1-8A3E-1A84A01524E1to_number( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq? ) , 0 ) !=0 then 19 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name?) =''tender''DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''UNKNOWN'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 20 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender''DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''CASH'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 21 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''CARD'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 22 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''CHEQUE'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 23 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name?) =''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''VOUCHER'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 24 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''COUPON'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 25 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''CREDIT NOTE'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 26 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''GIFT CARD'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 27 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''NO CHARGE'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 28 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq? DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''HOST STORE'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 29 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower( ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''ZURICH ACCT'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?>=0 then 30 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''UNKNOWN'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 40 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''CASH'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 41 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''CARD'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 42 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''CHEQUE'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 43 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''VOUCHER'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 44 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''COUPON'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 45 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''CREDIT NOTE'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 46 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''GIFT CARD'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 47 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''NO CHARGE'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 48 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''HOST STORE'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 49 elseif DF42E762-F9EA-42d1-8A3E-1A84A01524E1lower (~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Line_Source_RT_Name? )=''tender'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG2#VARCHAR#S_Orig_Linked_Rec_Seq?DF42E762-F9EA-42d1-8A3E-1A84A01524E1is null DF42E762-F9EA-42d1-8A3E-1A84A01524E1and DF42E762-F9EA-42d1-8A3E-1A84A01524E1Upper(~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_MoP?)=''ZURICH ACCT'' DF42E762-F9EA-42d1-8A3E-1A84A01524E1and ~67b680ab-2faf-4a43-aa7d-d28d1eae1620.67b680ab-2faf-4a43-aa7d-d28d1eae1620_DG1#VARCHAR#S_Tender_Local_Amt?<0 then 50 else 0 end'
SELECT	DATALENGTH(Val),
	Val
FROM	@Bug

N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

AdiI
Starting Member

31 Posts
Posted - 2009-08-21 : 00:01:28
hello once again i'm still facing same problem. i have declare column with varchar max it can store 2 billion character. now i have 22366 character in my column value. when i inserted record it runs successfully. but sql server 2005 select show only 8000 character and i want to 22366. plz help i have set all option value place result in file or grid but cant change default. is there any way to extract all character. plz help

adeel
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2009-08-21 : 03:42:15
Tools -> Options -> Grid Results

Change 256 to 48000 or similar.


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

AdiI
Starting Member

31 Posts
Posted - 2009-08-24 : 00:55:40
i have tried this but this option not let me allow to set value more than 8192 character. if i manually assign value greater than 8192 it does not change. it remain at 8192 i'm wondering at this i think it is SQL Server Bug. becoz if we store 2billion character in varchar max than sql server should be capable to show all character in output. now plz help how i get 23000 character column values? plz it is requested to all expert help me. is there any third party tool or any other solution

adeel
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site