PRSQL9109006: Convert from INT NULL to VARCHAR Fails

ID Number: Q76566

1.11

OS/2

buglist1.11

Summary:

Problem ID: PRSQL9109006

SYMPTOMS

Converting columns defined as INT NULL, SMALLINT NULL, or TINYINT

NULL to VARCHAR by using the CONVERT function, results in the

following error message:

Explicit conversion from 'int null' to 'varchar' unimplemented.

WORKAROUND

Either of the following two CONVERT statements will succeed:

CONVERT(VARCHAR,(CONVERT(CHAR,int_column)))

CONVERT(VARCHAR,(RTRIM(CONVERT(CHAR,int_column))))

STATUS

Microsoft has confirmed this to be a problem in SQL Server version

1.11. Microsoft is researching this problem and will post new

information here as it becomes available.