My cat's SQL smells like SQL

[Beau]

Originally posted by: KnightBreed

Yep, normalized data is a Good Thing?. A couple questions/comments:
1) Make sure you check the length of the string before hand so you don't get any erroneously typed phone numbers.
2) For f*cks sake buy a SQL book.
3) What happened with the issue you were having the other day?

It's in the software forum, still an issue AFAIK.

 

[phatcow]

what is the frontend of it like?

if its html, couldnt you make a JavaScript function to validate it?

 

[Spooner]

i'll update in a minute

 

[Beau]

Originally posted by: phatcow
what is the frontend of it like?

if its html, couldnt you make a JavaScript function to validate it?

He needs to do it completely in SQL & PL/SQL

 

[Beau]

Originally posted by: Spooner
i'll update in a minute

Oh boy, oh boy! I can't wait!

 

[pyonir]

I took an intro to SQL class last week.

But, like everything else, this one is over my head.

 

[Spooner]

Guys..... let's change gears to the other issue....

this one may go away and become a non-issue, i talked to the vendor

Let's go back to the one in Software and blah blah forum

oh, and thanks again!!!

 

[Descartes]

The guy asks for help w/ data in Oracle and he gets Perl and VBScript samples; gotta love it

The problem I'm running into is that the field the person has to enter their phone number in Oracle is an open field and they're entered in all different ways

Is there any level of determinism here? I've dealt with the same issue you describe, but I could always discern a familiar pattern. Do they have alpha characters in them, do some contain less than 10 numbers, etc.?