I have a field in a table which contains a string including Carriage
Returns, can anyone tell me how I could separate this field into separate
fields based on where the carriage returns are using a simple SQL command.
>I have a field in a table which contains a string
>Returns, can anyone tell me how I could separate this
field into separate
>fields based on where the carriage returns are using a
simple SQL command.
I have one table that holds physicians and another that
holds their specialties. There can be multiple
specialties for each physician. I need to combine all of
the specialties for that physician into a coma-separated
field that will show up in a provider directory. My
tables are setup similar to the following:
1 Dr. Smith
2 Dr. Jones
1 General Surgery
I need the output to look like the following:
Dr. Smith General Surgery, OB/GYN
Dr. Jones Pediatrics, Neonatology
It is unlikely that a physician will have more than 3 or
four specialties so I should be able to store the results
in a varchar(255) field.
6. Visual SQL