SQL Query to return result with and without whitespace

Question

I have a column in my Postgres database table which contains a value with some whitespaces in between. For example, a value present in the column is '123 1062 10'.

Now, I want to write an SQL query which can return the row which contains the above-mentioned value by passing in the value '123106210' in the where clause of SQL Query.

Any ideas of how can write to the SQL Query to get the desired result?

Tomáš Záluský · Accepted Answer · 2020-08-18 21:43:22Z

2

replace function does not work for you?

This works

select replace('123 1062 10',' ','')::bigint

so this could be your final select:

select ...
from ...
where replace(your_text_column,' ','')::bigint = 123106210

answered Aug 18, 2020 at 21:43

Tomáš Záluský

12.3k4 gold badges44 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

SQL Query to return result with and without whitespace

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