Peter
Your reply made it dawn on me that the PATINDEX I had was wrong. If I
search for an appropriate PATINDEX, it works AND cuts 10 seconds off page
rendering time (without caching on). With caching, the page is down to
40ms!
Thanks!
Steve
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 5 June 2001 12:12 AM
To: Spectra-Talk
Subject: RE: SQL Gurus - HELP!!!
Hi Steven,
Hmm, I thought that's why you check for characters that don't match
%,%,% ... perhaps I presented an example with too many wild characters, but,
anyway, play around with the results - it seemed to work for me.
Pete
-----Original Message-----
From: Stephen Collins [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 6:20 PM
To: Spectra-Talk
Subject: RE: SQL Gurus - HELP!!!
Peter
Thanks, but won't the PATINDEX for my requirement - 1 comma ONLY - end up
getting me ANYTHING with a comma in it? For example, doesn't %,% mean "0-n
characters of any description followed by a comma followed by 0-n characters
of any description"? In which case, I potentially get returns with multiple
commas...
Slap me down if I'm wrong.
Steve
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
