CONCAT in WHERE?

Is this possible? I tried CONCAT(FirstName, ’ ', LastName) = ‘Tim Jones’ and it isn’t working.

Thanks,
TIm

Hi, @Tim_Jones

Try creating a generated column in the table with the expression CONCAT(FirstName, ' ', LastName). Then you can use an expression like this: FullName LIKE 'Tim Jones'.

Regards,
Marina

Thanks, @Marina.Rudenko.

Is there a performance impact to having a generated column? I only need this for one small feature and want to ensure I’m not impacting performance.

Tim

There is no performance impact to having a generated column.

Regards,
Mark

Thanks @mark-piller!