No matter what I do I always mess up the syntax

In sysobjects find an ID of the record where the field 'name' is the same as the name of you UDF. Then find the record(s) in syscomments with the same...

Too bad baceuse I think I have something that can do it with the number so you will just have to convert the VARCHAR to proper number yourself

Can it take the SQL weekday values instead of VARCHAR. 

6 instead of Friday?

Well, Chris gave you an example that worked so there was no need for fixing the syntax of your code since in this case the usage of CASE was not...

"The case statement is used in the select clause not the join clause"

I have to disagree with this statement. There is nothing syntax wise preventing you from using CASE  in...

How about this:

select * from tablea

INNER JOIN tableb ON tableb.property LIKE '%tablea.property%'

PS. Changing CONTAINS to LIKE should do it. I just don't like the old linking syntax anymore.

Maybe this can help

http://blogs.msdn.com/brada/archive/2004/01/09/48925.aspx

The suggestion Ian gave you is fine in development environment, but be carefull with this in production with multiple users using your database. The Begin Transaction and running test SQL...

I created few little SPs to help me with some of what you trying to do. They work for me but you may have to modify them to fit your needs.

CREATE...

If you provide the table definitions for both we can see what can be done.

In my opinion CELKO's approach is a purist view of how the database should be build and has nothing to do with real life.

For example you have a database of...

I think this is only the 'Active Topics' forum issue. The combo box for sorting there has only one entry. If you go and browse the other forums everything works...

Look at all the tables starting with sysjob in msdb

Sorry a little cut and paste typo

It should be something like this:

SELECT * FROM table1

WHERE

(DATEPART(quarter, @date) = 1 AND DATEPART(quarter, table1_date) = 4 AND YEAR(table1_date) = YEAR(@date) -...