Home Forums SQL Server 2008 T-SQL (SS2K8) Problems with IsNumeric and PatIndex when trying to convert string to Int/BigInt RE: Problems with IsNumeric and PatIndex when trying to convert string to Int/BigInt

  • If there is a way to award points or give credit, I don't know what it is, but all three of you helped me with this. I believe it is probably a space within the string of numbers. When I added the Replace of a space with an empty string, it worked.

    Thank you.

    If there is a way to mark your answers as the answer, please let me know