Column name with special characters

Question

I have web service which returns a datatable with the following column name:

Id@qb>type

I am applying the following filter statement to this datatable:

[Id@qb>type] IN (0, 1, 2, 3, 4)

But whenever I use this column name in the filter statement it throws the following exception:

Invalid column name 'Id@qb>type'.

Thanks.

Answer 1

I'm not sure exactly how you're using the column, but I can think of two possible solutions:

1) Refer to the column by index instead of name.

2) Modify the procedure you're using to fill your Datatable so that it uses an alias for that column which is more code-friendly.