Обсуждение: Help on Converting data types

Поиск
Список
Период
Сортировка

Help on Converting data types

От
Marcio Macedo
Дата:

--
____________________________
Marcio Macedo
marciom@conectiva.com.br
Conectiva Internet Solutions
It's Red Hat Linux !!!


Hi...

I need to convert a char field to a integer filed in order to increase
the value: something like this

COD_Customer char(6)   ex.: 410023 (suposing that this is the last code
added)

So, when I insert a new customer I need  the code 410024.... and the
next will 410025... etc...
How can I do that ?