Forum Discussion
How we include double space in sql squery
hi sir, in sql i select the query using some condition value have new line space in that i did not got any result Example: select name from username where name like '% senr lim mint...
To be true, I don't understand a word, not what for data you have and what the problem is.
Please post table design as DDL, some sample data as DML statement and the expected result.
Please post table design as DDL, some sample data as DML statement and the expected result.
in sql i use select the query using some condition value have new line space or double space
in that i did not got any resultExample:
SQLselect name from username where name like '% senr lim mintu%'
if i give like this:SQLselect name from username where name like '% senr %'i got result
customer have gave like new line or double space as before i try "select name from username where name like '% senr lim mintu%'" like this- Then cleasing your data.
