Forum Discussion
Daryl1050
Aug 20, 2022Copper Contributor
IF Condition failing because ISNUMERIC Expression Not evaluating properly
Greetings. I have an IF Condition going down the wrong path as the code isn't evaluating an isnumeric condition as expected. I have debugged it in VStudio and see the following. I have a Substring th...
Ronen_Ariely
Aug 22, 2022MVP
Hi Daryl1050
in order to reproduce your scenario please provide
1) Queries to CREATE your table(s) including indexes
2) Queries to INSERT sample data.
3) The desired result given the sample, as text or image of excel for example.
4) A short description of the business rules, and how you got 1-2 of the results
5) Which version of SQL Server you are using (this will help to fit the query to your version).
Regards,