How to write like clause in load statement?

[#1]

Hi,

I want to refine the data loading in the LOAD statement with help of like clause?

LOAD * from project.qvd (QVD) where project_name like 'projects.%';

Thanks

Samir Sinha

[#2]

¨Have a look at the wildmatch function, that does exactly what you want.

[RickWild64]

You can use 'like':

Load * from project.qvd where project_name like 'projects.*';

should work.

The test is not case-sensitive, so the test above would load 'Projects.xyz' as well as 'projects.xyz'. Wildcards include ? (match a single character) and * (match any number of any characters)

[#4]

try like this..

LOAD

if( WildMatch(project_name,'projects*') = 1,project_name) as project_name

from project.qvd (QVD);

regards

A'run'

[#5]

Load * from project.qvd where project_name like 'projects.*';