data type question

• 71 camaro

  SSC Eights!

  Points: 911

  More actions

  May 15, 2008 at 7:45 am

  #71595

  I have a table where a column is defined as varchar(10) nullable. The column name is zip_code.

  There is an account that appears to have a blank zip_code but it is not. I tested and am pretty certain it is not blank, carriage return or line feed.

  Any assistance on finding out what special character it is would be helpful.

  A developper wants to know what type of data it is so they can fix a bug.

  Any guidance would be appreciated finining what it is

  Here is an example

  select zip_code from email_table with (nolock)

  where member_number = '123456789'

  zip_code

  ----------

  *********************************************

  select len( ltrim(rtrim(zip_code)) ) from email_tablewith (nolock)

  where member_number = '123456789'

  -----------

  6

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  May 15, 2008 at 7:54 am

  #815881

  Maybe ascii(substring(field, 1,1))