thank you for your help... Since we are on select statements... would you know how i can format my output ex.: Select Date,Store,SKU,Flag,Qty,Price from Details where Date >= '03/17/09' output is 2009-03-17 00:00:00 5 921711 1 1 10.9600 i need an out like... 20090317 005 0000000921711 01 00001 0001096thanks rino

i got the date to work for now... Select CONVERT(char(8), TransactionDetailDate, 112),.... output is 20090317