Return Field When a Field Contains Text from Another Field

Hi,

I'm new to SQL and I'm trying to write a statement to satisfy the following:

If [Field1] contains text from [Field2] then return [Field3] as [Field4].

I had two tables where there were no matching keys. I did a cross apply and am now trying to parse out the description to build the key. 

Any help would be wonderful! Thank you.

August 25th, 2015 4:12pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics