If the occurrance of the character is always to be removed then do and update with

set col = replace(col, 'character','')

and so you minimize the number of updates use

where...

Where were you looking becuase to me it is all fixed width datasets and there is a record layout on the first page for FIPS55.

Here is where you can download...

Without going into any paritcular can of worms I have seen this done as well and probably is the best method I have seen used without braking the storage you...

What your talking about is how to control the effect at the client. That all depends on how you implemented there. I haven't had a chance to do much with...

Or meet him in person at SQL Pass if you get a chance to go when he is there.

I am an EBay fanatic. Haven't gotten finished yet and I realy want to get to "An Introduction to Database Systems" by CJ Date I picked up not long ago....

Recently while reading "Data & Databases: Concepts In Practice" by Joe Celko I came across the NCITS L8 standards. Of particular note is the following from part 4 (ISO 11179-4)...

There have been several AS/400 DTS questions posted here.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=144677

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=145080

http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=139274

or check out the results from goole for others.

http://www.google.com/search?hl=en&q=%28%22as%2F400%22+or+%22as400%22%29+site%3Asqlservercentral.com

Then not sure what it may have done. Check your network drivers and make sure you have file and print sharing still enabled would be the only other potnetial thing...

The master database is the heart of the entrie sql server and should be protected against user interaction at all cost which now you have created a security risk by...

I think you may want to chalk this up to what you plan to use for and personal preference.

If the basis of the view is something you may potentially reuse...

Of course the more columns you add the slower the system will run. It is a nice whay to try and cosolidate functionality to allow end users to add columns...

Could be if you didn't turn of the firewall feature or at least allow SQL connections after installing SP 2. Most likely is the case as (local) code be use...

I know of no setting that causes this. Is the menu the standard menu for this screen and is this occurring on any machine connected to that server or only...

If you are using SQL 2000 fortunately both charindex and substring can work with a text datatype value and text can be used as a data for inputs in a...