Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have a table that has been given to me to strip data into seperate fields
The table has one field that contains city,state and zip in one field and I need to seperate them into seperate fields. Normally I sue case statements an search for blank between the data, but ths has become tedious and ineffective. The reason being mostly is that the data normally looks something like this: 'Upper Saddle River NJ 07458' with many trailing spaces to the right of the string. I tried RTRIM function Replace all citystatezip with RTRIM(CITYSTATEZIP) but that did not eliminate the trailing spaces.
Is there an easier way to parse out this data???
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement