SQL and JS: Separating Concatenated LIKE Searches

[formal trellis]

Im looking operators but I cant find a way to implement this:

WHERE 
  CC.FirstName + ' ' + CC.LastName LIKE '%s%'

name{
  like: query
},
subname{
  like: query
}

There is no concat of things, subname and name go separated.
Any possible solution??

Attachments:
https://cdn.discordapp.com/attachments/967097582721572937/1232012309334065173/image.png?ex=66390be0&is=662696e0&hm=b9ddb939df354a5529018b0b57b4a1927abf81448ed56956f7885df51f13d7b7&

[worldly hare]

Original message from @thick lodge - Moved from #general message

New Community-Help Thread Created!

Help is on the way! To mark it as solved, use the /solve command. In the meantime, here are some existing threads that may help you:

Documentation:

• SEO Plugin
• Stripe Plugin
• SEO Plugin
• Select Field
• Relationship Field

[real slate]

You're trying to use two fields in the query?

[thick lodge]

Nope I just want to use one, the problem is that I want to concat name & username.
If change to 2 fields the problem is solved. But I want it to be 1 field and concat things if possible
@real slate

[real slate]

Hmm, I think you can create a virtual field that combines two fields?

https://payloadcms.com/blog/learn-how-virtual-fields-can-help-solve-common-cms-challenges