or SQL Service Broker as an alternative. Then you don't even have to wait until the job finished. It all depends on the...

The error message indicate the problem quite clear:

Try DELETE CovElig.* FROM ...

Wouldn't the WHERE clause be equal to

WHERE

fbt.cust_no != '0306A'

OR channel_cd in ('Correspond','Correspondent','Retail','Wholesale','IGNORE CHANNEL') ? :unsure:

Seems like I wasn't clear enough the code I posted could be used to...

Because it would not return a character value with leading zeros?

The function Matt posted...

instead of using LEN, you could get the same result with (assuming the purpose is to add leading zeros)

SELECT RIGHT(10000000 + CAST(idnumber as INT),7)

where id < 1 000 000

Edit:...

Can you post the function?

Second question: is there any specific reason to use FLOAT instead of NUMERIC() or DECIMAL() (or even INT)?

if you want to insert three "groups" of data you should use three insert statements, each one with its own group by clause.

There might be a way to build one...

I'm not sure if I understand the concept. So let me ask: why do you have three parameter instead of just one?

Based on the description it should be easy to...

If you don't have a datetime column in the table in question holding this information and there is no kind of auditing (e.g. capture data modification in a separate table...

It's funny how a typo actually summarize the problem... (just look at the last line of the previous post) 😀

Without changing any code you won't get any change in...

One reason for not having a reply might be that we don't have enough information.

What type of "search criteria" are you looking for? Does the full-text search meet your requirements?...

Thank you for providing ready to use sample data. Made it much easier than just based on the verbal description...:-D

It is assumed that the version number will be ascendign without...

If during the original design phase someone had such a scenario already in mind (and therewith decided to use unicode data type (NVARCHAR() / NCHAR() ) for both, table structure...

I don't think there's any real chance to catch a "bad guy" with the methods "they" show at the airport nor the stuff they've come up with at airplanes (plastic...