Hi all
How can i join two values to form a single value?
Say in my database one field is 'ID' and another is 'ACC'. I want to join both field with seprator 'B'. For example if ID = 45 and ACC is 99 , the joined value should be "45B99" ( no blank space between the values) .
Thanks in Advance
ssp2000
