Hello friendsI am using below query but it returns only second select statement 1M data not showing postgre sqlselect 34ImageFilePath34 from 34RibbonImage34 where 34ImageFilePath34 is not null and 34ImageFilePath34 like 391M39UNION ALLselect 34ImageFilePath34 from 34RibbonImage34 where 34ImageFilePath34 is not null and 34ImageFilePath34 like 391W39 limit 2

Postgre SQL: Like operator with Where condition not showing data

sureshMG...

SOLVED CLOSED ACTIVE ANSWERED
User: sureshMGR
Posted: on Oct 17, 2022 11:31 PM
Forum: Data Controls
Replies: 2
Views: 762

Hello friends,

I am using below query but it returns only second select statement, '%1M%' data not showing (postgre sql)

select "ImageFilePath" from "RibbonImage" where "ImageFilePath" is not null and "ImageFilePath" like '%1M%'
UNION ALL
select "ImageFilePath" from "RibbonImage" where "ImageFilePath" is not null and "ImageFilePath" like '%1W%' limit 2;

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
User: dharmendr
Replied: on Oct 18, 2022 12:51 AM
Report

Hi sureshMGR,

This is case-insensitive issue in the query.

So use UPPER function to convert the strings to upper case before comparing.

Refer below modified query.

SQL

SELECT ImageFilePath FROM RibbonImage WHERE ImageFilePath IS NOT NULL AND UPPER(ImageFilePath) LIKE UPPER('%1M%')
UNION ALL
SELECT ImageFilePath FROM RibbonImage WHERE ImageFilePath IS NOT NULL AND UPPER(ImageFilePath) LIKE UPPER('%1W%') LIMIT 2;

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Postgre SQL: Like operator with Where condition not showing data

Company

Explore

Follow us

Contact Us