Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Raoul
Starting Member
2 Posts |
 Posted - 2011-11-09 : 05:13:31
|
| HalloI need help with a small sql projekt.What I have got:Phonenumberwhat I need:I need to check the sting to see if the number is shorter than 6 digits if it is I have to insert 0 for the number.I need to check if there is a hex in the number if there is i need to make the first 4 digits int else the first 6 digits.I have no idee how to even start on here just using mysql/sqlcan someone pls help me.RegardsRaoul |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-09 : 06:29:49
|
| are you using mysql? if yes, please post in some mysql forums. this is ms sql server forums------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Raoul
Starting Member
2 Posts |
Posted - 2011-11-09 : 06:31:09
|
| Sorry my mistake |
|
|
|
|
|
|
Phonenumber Check