The names of the columns (sometimes referred to as fields) and table(s) storing the email addresses in question (or if you have the whole database schema, that would be fine, too).
I would suspect that the email addresses are all stored in one column of one table, so I'm not thinking this would be a really complicated select statement. We should probably take the details off the list, I can post the results back here if the others are interested. - Byron -----Original Message----- From: Webmaster Oilfield Directory [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 1:05 AM To: [EMAIL PROTECTED] Subject: [IMGate] Re: Help on REGEXP Hi Byron: Coooool! yes i am using MS SQL server 2000 i believe.... what exactly do you need, so i can send that to you.... that would be greatly appreciated.... Sheldon ----- Original Message -----=20 From: "Byron P Hynes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 08, 2003 5:51 PM Subject: [IMGate] Re: Help on REGEXP > > If it's MSSQL, send me the schema and I'll write you the required SQL > select statement. > > You could use DTS, but it's a bit of overkill. All you need is one-line > batch file. (Use osql to process the select statement and send the > output to an output file). This could be scheduled to recur by > SQLServerAgent or by Scheduled Tasks or AT or any similar utility. > > - Byron > > -----Original Message----- > From: Len Conrad [mailto:[EMAIL PROTECTED] > Sent: Monday, September 08, 2003 9:29 AM > To: [EMAIL PROTECTED] > Subject: [IMGate] Re: Help on REGEXP > > > > >that's fine if your using imail to store addresses but what about if > your > >using an external database like sql ??? > > can't you hack something with DTS export? > > Len > > > > >
