Nevin,

Let's get rid of the nonsense.

Here is a real life NZ number:

Micrisoft New Zealand

09-362 5800

To call it from abroad you need to dial

{you country international access code} 64 9 362...

Can only agree with Nevin.

When you apply this operator to a varchar field you force an implicit conversion which may fail if a value cannot be converted to int.

That's where...

No, I'm...

you might wish to get familiar with arithmetic operators used in T-SQL:

https://msdn.microsoft.com/en-us/library/ms187716.aspx

Luis Cazares (5/5/2015)

I agree in your first statements because there should not be a relation between title and gender because they're different attributes of a person (person is the entity,...

- mistake #1

hardcoding data in a routine code - mistake #2

Implementing relations between entities (title and gender) in conditional procedural...

CREATE TABLE dbo.GenderTitle (

Title varchar(50) PRIMARY KEY,

Gender varchar(20) not null

)

INSERT INTO dbo.GenderTitle

(Title, Gender)

SELECT 'Mr', 'Male'

UNION

SELECT 'Ms.', 'Female'

UNION

SELECT 'Mrs.', 'Female'

SELECT *, ISNULL(Gender, 'Unknown') Gender

FROM dbo.Person P

LEFT JOIN dbo.GenderTitle GT ON GT.Title...

It seems saying "Yes, I see - storing phone number as a single string does not work" is simply too hard for you. 🙂

P.S. What is so outdated in fax...

It only seems simple for someone who never had to deal with real calling systems.

5 developers for almost 2 years...

Exactly.

If you hid the trouble inside of a computer it does not mean it's gone.

TomThomson (5/1/2015)

---

I'm somewhat at a loss as to why a phone cares about format. When I make a call, my phone simply pushes out the sequence of numbers that...

So, we have 2 options:

1) store...

Most of the numbers stored in my phone contain country codes, even for my own home number. Just in case I'll use the...

TomThomson (4/28/2015)

---

Is the US banking system still using the old thoroughly insecure renewal/replacement system which I seem to remember from the 1960s and 70s? If it does that would...

Nevyn (4/28/2015)

---

Or more appropriately it is analogous to storing phone numbers. Usually the formatting is stripped out before storing, but I don't think I've ever seen one stored as...