Cool, that worked so well. Thanks Jack

Thanks Guys i used the charindex without sign function to resolve this. Thanks for everybody;s input.

Sorry Chris, heres some more details wrt data and table structure

create table Table1

col1 varchar(10),

col2 varchar(25))

Data looks like

Col1Col2

specific ABCD

specific-1BDOP

specific...

Also i have a st.rpoc which i am calling thru isql. Thsi is takingw aytoo long than expected. I have put debug msgs in thsi proc to cehck which part...

One of the table thats used in st.rpoc gets updated repeatedly and thsi has numerous indexes on different columns. wont thsi slow down if there are inserts/updaes happening on this...

This is our prodn transactional server which is pretty busy during the day, but this st.proc runs during off hrs as a batch job so shouldnt have any impact on...

Basically i want to know how much total bytes(by all columns) is occupied in a table . i woked it out anyway. Thanks so much for the help..

select sum(length)...

Unfortunately teh structure is different . My process first get data into teh master table where new famid is generated. Now in all referece tables i need the new famid...

Exactly all databases have same table and table has same structure across all dbs. all i need is to pick one db at a time from say one temp tabl...

This is justa  sample st.proc wherein i am using a cursor within a cursor. if i execute it thru st.proc it works fine. Is it something that can be executes...

I am not sure if its something to with 2005 version but i have an id with dbo privileges but still if i use that id to check all processes...

So does that mean this setting has configured default value as 255?

My Dts have a a flat file with a sql server connection and data gets loaded using transform data task. Whats the best approach to check for null values? I can have...

No i havn't tried this before. Any suggestions on this please. TIA

I have a DTSPump taskw here transformatiosn are set up from a text file to a sql table. Thsi runs for multiple files on a  single folder. ALso in the...