using SQL Server 2000, SP3.
I have a scheduled DTS package that queries against a source table and inserts the values into another table. The source table contains several char columns that contain only spaces. I am inserting these values into varchar columns and want to prevent inserting values that contain only spaces. Does anyone have any ideas on how to go about this? I was thinking of building a UDF to handle this, but need some suggestions to get me headed in the right direction.
Thanks in advance,
Jim
I have a scheduled DTS package that queries against a source table and inserts the values into another table. The source table contains several char columns that contain only spaces. I am inserting these values into varchar columns and want to prevent inserting values that contain only spaces. Does anyone have any ideas on how to go about this? I was thinking of building a UDF to handle this, but need some suggestions to get me headed in the right direction.
Thanks in advance,
Jim