Re: char to int conversion

dario wrote: > > I would like to make some math operations with char entity > (in database). > The entity is all numbers but it is defined like char when > create table was made.> Is it possible to make some kind of chat to num conversion > inside sql query without altering table? > > Thanks > Dario Primorac Hi, if your tables are huge and if you do this maths frequently, it can pay off to convert the CHAR columns to {INTEGER, DECIMAL,.. whatever ...} by making copies and to use those shadow tables instead. To sync will be your responsibility and you need substantial disk space also. But you will gain speed. dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe