Geez ~ Sorry - I'm new to the forum and thought SSCoach was a nickname...

Thank you Jonathan, Scott & Jeffrey for helping me with this

Mark

Ahhh

SS your question inspired ~

I changed my original query to the following:

[Code]

SELECT  AKey

FROM dbo.AKey

WHERE LEFT(AKey, 3) IN ('AAA', 'BBB', 'CCC', 'DDD', 'EEE', 'GGG', 'JJJ') AND LEN(AKey) = 9

[/Code]

This works perfectly!

What...

SOLVED!!!
Okay, so changing the @EditDate in the stored procedure from:
[Code]
@EditDate Date
[/Code]
To:
[Code]
@EditDate DateTime
[/Code]
Did work with Now() as a parameter
However, what I...

Hey Luis ~ Thank you for the info. I hope my response reflects at least some understanding; however, I am still very new to SQL

Below is the code...

Hi Sue ~
Sorry for the late reply and the cryptic explanation... The line causing the error was the 'WHERE' clause...I have since moved to another task and may address...

OMGee!!

Luis & Lynn,
I cannot thank the both of you enough!!!
I came here for help and enlightenment ~ and you provided both in my first post...
Thank...

Not sure if this is the answer but I am using the following in 2008 and it works great

TableName.[First...