Sorry Carol, but summing CustomerId with OrderId looks to me as summing Prices with House Numbers.

So, I have three possible answers:

1. http://www.sqlservercentral.com/articles/Best+Practices/61537/

2. 42

3. wait for someone who will understand...

You cannot use column name as predicate in Full-text searches.

Predicate must be 'freetext_string'

Which means, you should build it from your "table of predicates", then use in CONTAIN.

It is...

GilaMonster (2/12/2014)

---

Eugene Elutin (2/12/2014)

---

GilaMonster (2/12/2014)

---

Eugene Elutin (2/12/2014)

---

...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't...

GilaMonster (2/12/2014)

---

Eugene Elutin (2/12/2014)

---

...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't be enforced through...

That is not a small topic.

The best place to start from would be MS BoL:

http://technet.microsoft.com/en-us/library/ms142571.aspx

Try and play. When you will have some specific questions, I'm sure you will find...

...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't be enforced through procedural or application...

Scalar functions of this sort are not very good performers...

Any way looks like OP has quite a specific rules, not just take non-alpha characters away. He also wants to take...

MyDoggieJessie (2/12/2014)

---

I'm certain there's better ways to do this but I'd recommend creating a function that can be called as needed - this may help:CREATE FUNCTION [dbo].[fx_SplitColumnText](

@String varchar(50),

@Delimiter varchar(5),

@Side int

)...

if you have wild card at front of pattern - the search cannot be optimised much, as full scan will be performed regardless of existing index, if any

If you have...

I wonder what have you tried to search for?

Google search returns a banch of topics. One is here leading to sample:

http://stackoverflow.com/questions/1673265/how-to-write-number-to-word-function-in-sql-server

I'm sure you will also find something searching SQLServerCentral itself.

Yes, it is possible. However, you will make your...

Not very clear what you really want. The best what you can do is to read the article from the link at the bottom of my signature, it should help...

How many records your query returns? It may...

You are trying to TRIM the value in the column which doesn't exist!

You or someone else was not very accurate while changing table definition and added space to the name...

Looks like you have a space at front of the Cost, so yuor full column name is [ Cost]. Rename it to remove the space