If you visit the NSCA website, there should be a directory of CSCS in your neck of the woods. If not, there should be a contact number/email.
I have a high degree of respect for guys with CSCS such as Reinold, Cressey, and Ranfone (if you haven't had a chance, you should read the articles he posted on this site).
That said, I have no doubt they will tell you that attaining a CSCS will not automatically make anyone a first rate coach. It's what each individual does as far as continuing education coupled with a desire to be great that sets them apart from the confederacy of dunces.
I currently hold NASM CPT, CES, PES as well as the FMS (Functional Movement System) certs.
I am also getting ready for my CSCS exam NOT because the information from the NSCA is so profound (in fact, much of the info in the textbook is embarrassingly outdated).
No, I've decided to obtain my CSCS because so many well-respected coaches and PTs (such as Mike Reinold) have it. Therefore, the PERCEPTION is that someone with a CSCS resides in some lofty perch. And, as anyone in marketing will tell you - one's perception is his reality.
The CSCS can open some doors that otherwise may remain closed. Of course, once I'm in, I'll have to prove myself - which I have no problem doing.
I'm sure you know this but for those who don't: NO cert or degree automatically makes anyone intelligent, insightful, and caring. For example, we've all met our share of idiots with MDs or PhDs.
So how do you or anyone else know that he's dealing with the real deal and not some bozo who is just good at memorizing text and passing an exam...?
Simple - ask for references (the more the better) and actually follow up.