here's a link to Chris's article on cluster that index

sorry FK...on this one topic I don't consult anyone...thinking cap's now officially "off"..

..oh..wait a minute..I (think) I am beginning to see some light...are you talking about the "fat lady" link I posted a couple of days back ?!?! If it is, you...

are you saying that my picture makes me look Hungry; voracious; greedy...

as for a moniker for you...am donning my "thinking hat" right now...will let...

hmm..thinking out aloud here...should I just let FK & GPF^192 continue making assumptions about me...should I just pretend to be a fly on the wall...should I jump in and say...

great start to a Friday morning..

I would use a stored procedure - pass the empID (& other values) as parameters...

& then do an

if exists(select * from myTable where empID = @empID)
   ...

If phill's right in his assumption of "oversimplification of code" then you should use his SQL - else Manish - it may be in your best interests to post what...

thanks lancea - for adding another piece to the PASS picture! Pity about having to say "no" to books...

I think you must have me confused with remi...he should be the one in the jacket...

"Yo - banana boy!" - surely you mean palindrome..

I noticed the sucess with links in the monty python thread...congratulations!

as for the moniker...it's almost like christening yourself...

eyal...I haven't looked into this in detail but this script shows some promise..check it out and see if it gets you started in the right direction...

script

farrell - use it like so...& "view page source" for use of the anchor tags...

Curses & Blessings of Dynamic SQL

could you please post the entire code - or at least the part that includes the substring function...also some sample values from last_Name & first_name would help...