Adding string in select advance sql

  

Hi.


how can i add string in select query in advance sql query.?

I just want to convert this working ms sql query in advance sql query.

" select 'T' + right('0000000' + CAST(max(id) as varchar(7)),7) from table. " 


thanks.

Tams^

Solution

Hi Tams,

Please consider the below query as an example:-

SELECT 'T'+right('0000000'+cast(max(id) as varchar(7)),7) from {Booking}

and keep the output structure as Text, its working in my personal environment.

Thanks,

Manish Jawla

Solution