SQLite - How to replace string operators and convert it into integer value?

Question

I have a string column which has dots.How can I replace the dots with nothing("") ? After the replacing , I want to convert this string into integer value.

For example :

1.450.753 (String)

to

1450753  (Integer)

gingerdd · Accepted Answer · 2017-09-12 20:25:43Z

2

SELECT * FROM Table WHERE CAST(replace(yourString,'.','') AS INTEGER) > otherValue

I think this is the answer.

answered Sep 12, 2017 at 20:25

gingerdd

358 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLite - How to replace string operators and convert it into integer value?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related