How do I convert a string with trailing sign to a signed integer?

• mikelordi2

  Mr or Mrs. 500

  Points: 596

  More actions

  March 18, 2010 at 8:29 am

  #218056

  Hi guys...I am converting data from a flat file to a Sybase table with an assigned datatype of "Long integer". I am deriving the data from a flat file source that passes the string to me as such "000150000-" or "000150000+". I need to convert this string from that to a numeric value of either -1500 or 1500 depending on the sign and dividing by 100.

  I know i have to use a derived table to perform the transformation but am unsure how to do it on one line....anyone have any ideas?

• WayneS

  SSC Guru

  Points: 95460

  More actions

  March 18, 2010 at 9:16 am

  #1136047

  Duplicate post. Use http://www.sqlservercentral.com/Forums/Topic885560-1292-1.aspx discussion.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2