Hi, Update with "" It'll fill up the column with ... nothing ! Than fill it up with your text.
Robin. -----Message d'origine----- De : Zanatta Aaron (ST) [mailto:[EMAIL PROTECTED] Envoy� : jeudi 3 f�vrier 2005 17:18 � : '[email protected]' Objet : MI-L Populating a Column with text Hello, I am trying to update a column with text. I need the text to be repeated through all the rows of the table. There is however already text in the column in different rows, some rows are blank others are not. I have tried to use Table > Update Columns... then in the value section I entered >> column_name + "Text", this works for the blank rows, but not for the rows with text in them, it just adds the new text onto the end of the existing text. I can delete what is in the current column by changing the Table Structure to 'date' then changing it back to 'Character', but I don't like this method. Can anyone give me advice on a method to update this column or a way in which to delete the current data that is already in the coulmn??. Thanks Aaron ************************************************************************* The contents of the e-mail and any transmitted files are confidential and intended solely for the use of the individual or entity to whom they are addressed. Transport for London Street Management hereby excludes any warranty and any liability as to the quality or accuracy of the contents of this e-mail and any attached transmitted files. If you are not the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. If you have received this e-mail in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept for the presence of computer viruses. ************************************************************************* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15122
