Query-Problem 1

[psychodad71]

My table contains a field (m_akt) which discribes the day when to start a DTS-Paket. This works fine when to start once a month. I would like to insert 1,15,25 in this field to start the paket on the first, the fifteens and the twentyfifth a month. But this does not work.

Here is my query:

SELECT *
FROM DTS_Paket
WHERE (cast(DAY(GETDATE())as varchar(2)) in (m_akt))

Any ideas ?

 

[r937]

where ','+m_akt+','
like '%,'+cast(day(getdate())as varchar(2))+',%'

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)