we have some people at my company that like to see how far they can "hack" something - I would like to prevent that as much as possible.

alright that worked perfect thank you so very much

Luke first off thanks for 2 different replies to solve my issue -

First your entire first post makes a little sense to me however I am not the admin over the...

how many results is it returning?

Thank you very much - I would have never come up with that

thank you again

thank you I don't believe I didn't mess with the quotes usually the first thing I do.

Thanks again all who helped

I decided to use the datepart function and this query works in the query analyzer however I get this error

Error 1023 Invalid Parameter 1 specified for datepart

datepart("hh", dsd.start_time)

thanks

I saw that before and I guess I should have been a bit more specific sorry

IS there reallya  benefit to using views in a web application when I am controlling...

How to use the function to do what I need it to do

I place a table name wher eyou have systemObjects and I get the column names but I am...

alright man first off thanks for the help

and now sorry but I am not following at all  - I get that this is a user defined function so I created...

allright if you say so

Could you explain a little bit of what in sam hill that is doing?

thank you for the prompt reply I will try that - thanks again

Pefect it works great - thank you very much I never knew you could place criteria in the join commands - thanks again

still gave me the same result - only gave me the modules that the user had not all of them.

Would this be better done in the code side by comparing...