sorry - know nothing about MySQL but did find what seems to be a good link!

Unless you're looking for..

datename(dw, getdate())..?!?!

Since the datepart is dependent on the current setting of "datefirst"...check that first if that's the one you want..

This is how I'd do it in SQL2K...

If all you wanted was to convert the db colum to uppercase you'd compare..

where password = upper(colPwd)

If you wanted to match the case...

...If you're ever out of a job you should take to...

This thread has been cross-posted here!

This thread has been cross-posted here!

This thread has been cross-posted here!

Natalie/Nisha - pl. do not cross post - follow this thread here!

Is this the same question posted here?!

In EM you can expand the Management folder and see the status, last run date etc.. of the various scheduled jobs...or in QA you could query the system tables...something like:

select...

Of course Life would be MUCH easier if this could just be validated at user input stage...

Why David - have you not perfected the art of being model spouse (read: husband) who nods his head mechanically making automated responses of "yes...uh huh...that's right..whatever you say honey"..?!?!?!

I am consumed with curiosity.....maybe my particularly insulated existence prevents me from coming across many interesting situations and scc is the only place I know that allows me peeks into...

beer & pizza sound more like wishful thinking than anything else...

Never paid attention to it till I saw this post - to me it...

...if Joan of Arc "had a cellphone"....look at the sorry fate that befell her...wish we could set her up as an example of what...