I am trying to get the string that is within my quotes and not having any luck with the various ways I am attempting to do this. I have read only access so I cannot do a replace or update of the raw data. The raw data looks like this:
uniqueid memberfirst memberlast memberaddress membercity memberstate memberzip memberage dateofbirth
"111111" "john" "doe" "111 jones str" "Bronx" "ny" "10021" "25" "12/19/1965 00:00:00"
Don't ask me why the DBA built this table like this. None of the other tables are like this.
I have tried:
select distinct substring(uniqueid,'"','')
select distinct str$(uniqueid,'"','')
select distinct mid(uniqueid,'"','')
Nothing works