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