Hi I've got a table, Directory, with a field 'fullname', containing strings like 'Harlequin Theatre and Cinema'
I want to copy all the fullnames to a seperate table, login, to allow organisations to log into the CMS and modify their records. For an organisations's username I want to lower-case all the fullnames and remove spaces, such that Harlequin Theatre and Cinema becomes harlequintheatreandcinema Then I'll generate a password for each using the script someone kindly supplied a while back (alphanumeric string, upper- and-lower case) I can lower-case no trouble using Lcase, but I'm stumped as to how to remove the spaces. can anyone give me a clue? ta Ian W
