Forum Discussion

senthilnathan885's avatar
senthilnathan885
Copper Contributor
May 09, 2024

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

mintu%'

 

if i give like this

 

select name from username where name like '% senr %' i got result

 

but i want above like that

 

3 Replies

Sort By
  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    May 10, 2024
    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.
    • senthilnathan885's avatar
      senthilnathan885
      Copper Contributor
      May 13, 2024

      olafhelper 

       

      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

Resources