Just had this error when using the statement : Cannot specify a column width on data type real.

I moved real to the group without length :

Removed real here:

WHEN TYPE_NAME(COLS.[user_type_id]) IN ('float') --,'real')

Added real here:

WHEN TYPE_NAME(COLS.[user_type_id]) IN ('datetime','money','text','image','real')

Now it works.

Bart