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 BillNoFrom
BranchTransferMasterAdd prefix
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
Ex: Billnumber is 18
i want to add a string prefix during selectoin
Ex: AB-18
How to possible?
my select query is
Blocked AccountPosted Jul 22, 2011, 1:34 AM
write your query like that.
Select 'AB-' + .billNo as BillNoFrom
BranchTransferMasterBlocked AccountPosted Jul 22, 2011, 2:56 AM
try this
Select 'AB-' + CAST(billNo AS VARCHAR) as BillNo
From
BranchTransferMasterAbdu RafeeqPosted Jul 22, 2011, 2:43 AM
Msg 8114, Level 16, State 5, Procedure Branch_Ledger_Report, Line 22
Error converting data type nvarchar to numeric.