Needing help in an SQL script, I have a field name RESULT with a data type varchar, I would like to check how to get the integer value and convert to int to link to another table as relationship?

Transact-SQL
1

image

2 
TRY_CONVERT(int, RESULT)

This will return an int value if it can, otherwise it returns NULL.
What it will NOT do is find ints inside strings, such as abc123def.

image
image726×693 26.6 KB

3

Thank you very much, this is very helpful. :wink:

4

This would be fine for small tables. As the table grows you will have performance issues when converting the columns.
It is good to have the columns with same datatypes used in joins.