how to remove space in the column while comparing column values
Hello,
I am using a query to compare kernel values like below:
select value from MGMT$OS_KERNEL_PARAMS where name='net.ipv4.tcp_wmem' and value not in ('4096 98304 16777216')
The values for this is like below and I want to exclude net.ipv4.tcp_wmem with values 4096 98304 16777216 but still they are coming with value not condition also.Any way how we can compare a string with spaces in between?
4194304 4194304 4194304
4194304 4194304 4194305
4194304 4194304 4194304
16777216 16777216 16777216
4096 98304 16777216
4096 98304 16777216
4194304 4194304 4194304
4194304 4194304 4194304
16777216 16777216 16777216
16777216 16777216 16777216
4194304 4194304 4194304
4194304 4194304 4194304
4096 98304 16777216
4096 98304 16777216
16777216 16777216 16777216
4194304 4194304 4194305
4096 98304 4194304
4194304 4194304 4194304
4194304 4194304 4194304