error: Conversion failed when converting the varchar value ',' to data type int

0
votes

does any body knows why when I run this query its is error "Conversion failed when converting the varchar value ',' to data type int."<\font>

1
sql
Because comma , is not a valid number/integer? - Lukasz Szozda
any idea how to fix this ? - user3827642
SELECT TRY_PARSE(col_name AS INT) FROM tab_name. Use TRY_PARSE(SQL Server 2012+). - Lukasz Szozda
An idea how to fix it? There is nothing to fix. You are saying: "My string contains an integer number" and the DBMS tells you: "No, it contains a comma". So don't try to treat the comma like an integer. It isn't an integer. - Thorsten Kettner
mmm make sense silly of me I forgot those are int - user3827642

1 Answers

0
votes

It looks like error from ms sql server. In tsql you can use cast and convert
You should read this: Microsoft SQL Server Management Studio doesn't get OS regional Setting