well, I would guess it's something with the way you are calling your function.

This works fine...

declare @var varchar(1000)

set @Var = 'abceref'

select cast(@Var as text)

Reading is fundamental....

select  SUBSTRING(column1, PATINDEX('%[^0]%', column1+'A'), LEN(column1))

Functions like that will be run for each and every row in that table I am querying though vs. once in a set based operation.

Amen brother Phil!!!!

because I want it to actually run fast.

Problem is... that replaces all spaces.  Which is no good for what I am doing.

Yup I stole it..

yeah... actually I found that out already...

this is better

select  SUBSTRING(column1, PATINDEX('%[^0]%', column1+'A'), LEN(column1))

Forget it... I found it.

My buddy Bill here showed me the light..

select  REPLACE(LTRIM(REPLACE(columX, '0', ' ')), '', '0') AS new_col1  .....

Could you post the DDL?

That CPU # (if you are referring to the same CPU # in profiler) does not represent time, it represents the # of CPU cycles.

Recompute statistics will update statistics on all tables in the database.  This is highly recommended.  Poor stats will lead to poor performance.

Rebuilding an index is synonamous with reindexing.  As records...

Backup your database frequently

I have had to deal with this in the past.  I would recommend that you discuss this with the application...

yeah... definitely stuck in loading.  yeah.  definitely a monday.

Chris... sounds like you either had a really bad day, or someone ran over your dog today.  In either case, you just need to PRAISE JESUS!!!!!

And all will be...