Re: Challenging SQL Problem

2001-07-01 Thread Bob Hall
>Hello, > >I am having a lot of trouble trying to find the best >way to write the SQL to do the following: > >I have a table called "referrals." In this table I >have a column called "ref." The data in the ref column > >are of the form "p/$promo_id/$date". An example would >be "p/26/20010629" whic

Challenging SQL Problem

2001-06-30 Thread PHP Webmaster
Hello, I am having a lot of trouble trying to find the best way to write the SQL to do the following: I have a table called "referrals." In this table I have a column called "ref." The data in the ref column are of the form "p/$promo_id/$date". An example would be "p/26/20010629" which says p