Unanswered: SQL Query Help needed to convert Data Format
I need help for formatting my SQL Advantage SQL query while getting the Output.I have the following Column in the Database.
Column Name Type Length
------------- ------- ---------
release int 4
Actual Data stored in the Database (Sybase 11) for the above column is:
I would like to get the output (also NOT to consider the NULL, -1, 0 values) in the following format:
I would like to run the query through SQL Advantage. Can any of you help me to send the exact SQL syntax how to format the data to get my required output by using case, cast etc. As I have my output query running fine, I request you to send me the exact syntax for formatting this column only.
Note: Similar Python Script syntax available with us is : str(release / 1000000) + '.' + str(release / 10000 % 100) + '.' + str(release/ 100 % 100) + '.' + str(release % 100). Probably this might help you to understand better my requirement.
from (select release=
3030517 union all select
3030506 union all select
3191919 union all select