Skip to Content (Press Enter)
2025-01-17 04-53-26
Minh Quang Nguyen
20Views
3Comments
Solved
SQL dynamic expand inline
Question
SQL


I try to do sql like that. It ok when I test in studio

but at the run time, it return my sql is


SELECT {User}.[Username]

FROM {User}

WHERE {Users}.[Surname] LIKE ''%1%'' or {Users}.[Surname] LIKE  ''%2%'' or {Users}.[Surname] LIKE  ''%3%''


Therefore, it error by duplicate '


Please help me. Thanks



Untitled.png
0
0
08 Nov 2023
Copy Link
2025-04-10 12-15-03
Ankit Sheshkumar Shukla
Solution

Hi @Minh Quang Nguyen 

I hope you are doing well. 

Please refer this link. It may explain in detail way click here .



Regards

Ankit S



See solution in context
1
0
08 Nov 2023
Copy Link
2025-01-17 04-53-26
Minh Quang Nguyen

Thank you so much

0
0
08 Nov 2023
Copy Link
2025-01-17 04-53-26
Minh Quang Nguyen

This is my code

0
0
08 Nov 2023
Copy Link
2025-04-10 12-15-03
Ankit Sheshkumar Shukla
Solution

Hi @Minh Quang Nguyen 

I hope you are doing well. 

Please refer this link. It may explain in detail way click here .



Regards

Ankit S



1
0
08 Nov 2023
Copy Link
2025-01-17 04-53-26
Minh Quang Nguyen

Thank you so much

0
0
08 Nov 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.