View: dbo.Bank_Transaction_Sortable_Reference_Number_View | |||
View definition | |||
create view dbo.Bank_Transaction_Sortable_Reference_Number_View as select bank_transaction_KEY, sortable__reference_number = case when reference_number <> '' and reference_number not like '%[^0-9]%' then (space(40-len(reference_number))+reference_number) else reference_number end from dbo.Bank_Transaction | |||