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...
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 result
Example:
SQL
select name from username where name like '% senr lim mintu%'
if i give like this:
SQL
select 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.