Abdu Rafeeq

Abdu Rafeeq

  • NA
  • 113
  • 260k

Add prefix

Jul 22 2011 1:30 AM

 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  

Answers (3)