STR的sql命令(，，)FoxPro命令-sqlcommandforSTR(,,)FoxProcommand

I'm new to sql and would highly appreciate if some help to know the sql command for STR(,,) (return as a string of characters rounded to decimals) FoxPro command (See for description of FoxPro command). Thanks in advance for your help.

我是sql新手，如果您能帮助我了解STR的sql命令( ， ， )(返回为一串四舍五入的字符)FoxPro命令(参见对FoxPro命令的描述)，我将不胜感激。谢谢你的帮助。

Editted

编出

I need to convert this FoxPro command substr(str(borrower,9,0),1,1) to SQL command. Any help will be highly appreciated. Thanks

我需要将这个FoxPro命令子str(str,9,0)，1,1)转换为SQL命令。非常感谢您的帮助。谢谢

2 个解决方案

> SELECT '|' || printf('%10.1f', 123.456) || '|';
|     123.5|

Cast(Round(number,n), As VARCHAR(m))

 SUBSTR( CAST(ROUND(borrower,0) AS  varchar(10)),1,1)