I just make beer, so I only need a big brewing pot and nice big fermenter (I use 7 gal glass bottles). Getting thirsty just thinking about a...

untested, but it should be something like this...

update mytable

set city =

case

when city = 'TWP' then 'TOWNSHIP'

when city = 'BORO' then 'BOROUGH'

else city

end

Definitely pedantic but all is overlooked when the pedant uses words like quaff and is an MVP to boot...

you can also do this in QA...

SELECT DATABASEPROPERTYEX('dbName', 'RECOVERY')

Learn2Live - that pattern matching is much neater and infinitely more readable....

eko - if you're talking about collations, the only thing listed under BOL is:

"Latin1_General - 1252 - Afrikaans, Basque, Catalan, Dutch (Belgium), Dutch (Standard), English (Australia), English (Britain), English (Canada),...

Just to reassure you...you're not going blind...I stared at it for precisely one second because my focus was on the earlier post about including the comment line & getting an...

LOL - the evils of "copying and pasting"....

none was taken gilamonster...just felt i had to defend myself & mine is all...

Subhash - you do not need the single quote around the D - also not sure why the 'end paranthesis' shows up as a "wink" but hopefully that's what you...

You may take the backups but that should be automatically.....

Smruti - the only way you can safeguard database/yourself against accidental deletes is by having a backup of the database...

To Gilamonster...I wasn't casting 'A102' - only those colNames where the strings did not begin with 'A' or 'B' - that's because it seems I misunderstood the requirements...yet again...

you're right joe joe - my mistake - try this instead...Hopefully I've understood the requirement correctly this time:

select * from myTable

where colName not like 'a%' and colName not like 'b%'

and...

what is the frequency of this report ?! can it be scheduled to run at night so he has it first thing the next morning ?!

also...how much does the data...

joe joe - if i understand you correctly, you want all the rows that neither begin with A or B nor have numbers less than 99...if so, the query I...