Notifications
Clear all
Topic starter
I have some fax numbers which are disconnected (likely typos) going out through my fax server from CPS using a product called "Magic Fax". The fax numbers are pulled from a SQL query of the CPS DB. I would like to query the phone number to find out which physician has the bad phone number of xxx-xxx-xxxx.
It seems simple but SQL queries are not my forte. I can certainly run them though 🙂 Any help? This would be the fax phone number of the referring physician of the patient, I believe.
I am pretty sure it would start with select * from but that's about as far as I can go
Thanks
Posted : March 29, 2017 6:20 am
select * from doctorfacility where phone1 = '123456789' or phone2 = '123456789'
If you know the bad number, I'm 99% sure fax numbers are always in phone2 but it won't hurt to search both fields. Also in my database there is no -'s just the numbers.
Posted : March 29, 2017 6:28 am
Topic starter
Awesome, Thank you!
Posted : March 29, 2017 6:33 am
