Viewing 10 posts - 1 through 10 (of 10 total)
Seems to work the oppositie for me
SELECT * FROM #test1
WHERE col1
LIKE '%5%%'
returns both rows.
and
SELECT * FROM #test1
WHERE col1
LIKE '%5[%]%'
returns
some 5% interest
January 22, 2004 at 10:45 am
It seems to me that there is only one right answer and that would be
SELECT * FROM #test1
WHERE col1
LIKE '%5[%]%'
The reason is because the query should return a...
January 22, 2004 at 10:31 am
I was reminded last night at the Safeway grocery store about a major pet peeve of mine. Grocery store discount club cards.
To grocery store:
What I don't want is to give...
November 26, 2003 at 10:33 am
quote:
Did you look at the License.txt file on your CD?Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
October 2, 2003 at 10:04 am
I chose answer 1 and was surprised to get it wrong. Surprised because I tested it first by opening 2 query analyzer windows. With window one I set Northwind to...
August 29, 2003 at 11:07 am
Yes indeed Trea, as crazy as it sounds it is illegal to pump your own gas in the state of Oregon. I think there is or was one other state...
August 20, 2003 at 11:40 am
My first pet peeve is kinda dumb but it still is really annoying to me. When someone is giving me back change from a purchase I am making, why do...
August 20, 2003 at 10:27 am
Woops. Sorry. I forgot to add that you need to add an alias to the first select statement in order to create a column for the DTS task to use....
February 8, 2002 at 12:47 am
quote:
I tried that but it said there is no destination column.. When I take a look at the destination, it doesnt show...
February 8, 2002 at 12:38 am
I had the same need as you in that I had to put some data into a text file with a two line header of information. My final step was...
February 5, 2002 at 2:43 pm
Viewing 10 posts - 1 through 10 (of 10 total)