I have this Oracle Sql statement but I need to convert it to SQL Server Statement.
"SELECT LPAD('-', 2*(LEVEL-1),'-') || DESCRIPTION DESCRIPTION, LEVEL_CODE
FROM T_NBS_LEVELS"SQLStr=SQLStr&"
START WITH PARENT_CODE = 0"SQLStr=SQLStr&"
CONNECT BY PRIOR LEVEL_CODE=PARENT_CODE "

Sql Server gives Run time error message which is about LPAD is not recognized etc...

Also does anybody know a tool that converts Oracle Sql statements to SQL Server Statement?