How to divide a value into Two

[Vajrala Narendra]

Please give appropriate sql query

in a table i have a field Field1 of Numeric datatype
i stored 9.45 in that
how to separate that value (9.45) in two as 9, 45

please send appropriate query
Thank You

[mwasif]

Here is a simple example to achieve this
[CODE=mysql]SELECT SUBSTRING_INDEX (Field1, '.', 1), SUBSTRING_INDEX (Field1, '.', -1)
FROM table[/CODE]

[debasisdas]

For this the logic is to consider the number as string not number and findout the posistion of the "."

[Vajrala Narendra]

Here is a simple example to achieve this
[CODE=mysql]SELECT SUBSTRING_INDEX (Field1, '.', 1), SUBSTRING_INDEX (Field1, '.', -1)
FROM table[/CODE]

Thanks
i was tried it in sql2005 but it is giving error like 'SUBSTRING_INDE X' is not a recognized function name.
plz give appropriate query in sql2005

[amitpatel66]

Please give appropriate sql query

in a table i have a field Field1 of Numeric datatype
i stored 9.45 in that
how to separate that value (9.45) in two as 9, 45

please send appropriate query
Thank You

Try this:

[code=sql]

SELECT REPLACE('9.45', '.',',') from table_name;

[/code]

[mwasif]

Thanks
i was tried it in sql2005 but it is giving error like 'SUBSTRING_INDE X' is not a recognized function name.
plz give appropriate query in sql2005

SUBSTRING_INDEX () is a MySQL function.

Moving the thread to MS SQL Forum.

[ck9663]

try:

SELECT REPLACE(cast(Field1 as varchar(20)),'.',',') FROM table_name

--ck