Viewing 7 posts - 1 through 7 (of 7 total)
ScottPletcher (8/14/2013)
The code uses LIKE to compare the string, so just construct your string accordingly.<snip>
I'll add code to see the actual part(s) of the text that match if you want.</snip>
Yes,...
August 21, 2013 at 11:20 am
Thanks for the code! It works great if I know what I'm searching for, but unfortunately to be useful in my current situation it would have to return the actual...
August 14, 2013 at 11:56 am
Sorry for necro'ing an old thread, but I'm trying to do something similar. The difference is that I'm looking for multiple strings (matching a pattern) of varying lengths. I've tried...
August 5, 2013 at 12:38 pm
I had an older version of this script that I had inherited from my predecessor, stripped of any author information, and was just about to edit it so that it...
July 24, 2013 at 12:25 pm
Thanks for the assistance. I agree with your take on using a/b/c as aliases, but I was tasked with "get it working, don't get it pretty". I thought that replacing...
June 27, 2013 at 8:33 am
I'm having pretty much the same error...were you ever able to fix this?
February 9, 2011 at 9:03 pm
--minor changes so it works on a case-sensitive server
USE master
GO
BEGIN
IF LEFT(CAST(Serverproperty('ProductVersion') AS VARCHAR(1)),1) = '8'
begin
IF EXISTS (SELECT TOP 1 * FROM tempdb.dbo.sysobjects...
January 31, 2011 at 8:48 am
Viewing 7 posts - 1 through 7 (of 7 total)