I select Bill Number from a table ,Bill number dataype is nvachar,
Ex: Billnumber is 18
i want to add a string prefix during selectoin
Ex: AB-18
How to possible?
my select query is
BranchTransferMaster
Select .billNo as BillNo
From
BranchTransferMaster