Thanks so much again Lowell for coming to the rescue.

If the checknumber column is blank, then the money collected must be cash because check cannot be collected without check number.

So,...

Hi mates,

I am still having problem with this code.

This is the code from Lowell (Much appreciated sir).

select

CASE

WHEN ISNULL(chcknumber,'') = '' AND checkAmount <> ''...

Thank you so much Lowell.

Your assistance and prompt response, very much appreciated.

Thank you very very much for your prompt response.

I had tried the same code before but it doesn't add that 'Cash Payment' under the Check Amount column.

It doesn't show up...

WOW, great stuff!

Thanks a lot for the prompt response and your help. Works great!!

You guys are fantastic!.

I really appreciate all the time each of you has taken to share your ideas.

Thank you.

Things are looking up.

I really thank you and everyone else here for your great inputs.

You asked if they considered buying vs build.

No. The reason for that is we believe in our ability to...

Please don't refer it to as an assignment because it gives the impresssion that is an elementary project.

It might be for you and the experts but as I stated, I...

Thank you Welsh.

Year is calendar year.

I am confused about something.

You said to create a Payments table.

How is different from Dues table?

Ok, I *think* I got it.

Dues stores the $200.00 annual...

Thanks guys for your responses.

I actually did ask for follow-up questions similar your comments GSquared.

I have not gotten a feedback yet.

LOL, this is not a homework.

You can look me up...

That's actually a good question that I actually asked the users who told us that they all their maintenance items do not contain ALL numeric values.

They further stated that some...

it's quite interesting as to what sometimes seems quite simple often isn't.

The GrumpyOldDBA, you are soo right, LOL

You are right, I think it works now.

If I try this:

INSERT INTO maintenance(maintid, maintName) values(1, '12345')

It doesn't insert - the constraint violation error is raised.

The INSERT statement conflicted with the...

Sure, I agree - that's for integer though.

What prevents 1234 from being inserted into the maintName fieldname?

That's what I am hoping the constraint is intended to do - prevent it...

Thanks to both of you for the extremely fast response.

I ran Ninja's_RGR'us's code and this is what I got:

The INSERT statement conflicted with the CHECK constraint "Only_Characters". The conflict occurred...