I have a data extension with a text field that contains numbers like 25.00, 130.00.
I'm trying to convert that to a number field so I can write a condition number greater then but because its a text field doesn't work
I looked for other topics related and tried cast, convert, replace but nothing seems to work
SELECT CAST(CAST (Address_ID AS NUMERIC(19,4)) AS INT) AS Address_ID FROM table_1 SELECT CONVERT(INT,Address_ID) FORM table_1 SELECT REPLACE(Field1,',','.') as 'Field1' FROM data_extension SELECT FLOOR(REPLACE(FIELD1,',','.')) as 'Field1' FROM [data_extension]
Any other ideas?