How to sum, if the field type is character type?

vieruodis

SELECT SUM(cSng(mid(editorPay, 4))) AS editorPayTotal FROM table1

Among them is editorPay character type
For example: RMB33.45
      RMB136.55

Syntax error? Please give pointers, thank you!

cv4bf5d65fd

SELECT SUM(cSng(cast(right(editorPay,len(editorPay)-3) as numeric(9,2)))) AS editorPayTotal FROM table1

vieruodis

Thank you very much, it is finalized in one fell swoop^_^

ilgold

Use LEFT RIGHT MID LEN and other character processing functions to remove RMB, then use CLNG CDBL and other functions to transfer it to process it.

小老鹰

Use Mid(), left(), right(), cdbl() and other functions for processing.

Access does not support the cast() function, which is a function of SQL Server.