Trigger or Insert issue: Not generating the correct data

• Lowell

  SSC Guru

  Points: 323522

  More actions

  February 28, 2012 at 11:42 am

  #1452757

  Gianluca Sartori (2/28/2012)

  ---

  ram_kamboz2k7 (2/28/2012)

  ---

  if bigint is an issue, can nvarchar be used for the telephone number?

  Thanks

  varchar would be a better choice. I highly doubt you will ever need to store unicode characters in telephone numbers.

  we use varchars here;

  we get a lot of data like "1-888-555-1212 ext 223"; our users prefer to have a single field where they can include the extension instead of a separate optional field.

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!