How do I select a names with four characters from a table using Wildcards.

Answer 1

safik

Answer 2

select names from xyz
where names = "____";

//just use 4 underscores and try

Answer 3

Unfortunately four underscores couldn't work. Thanks though.

Answer 4

Yes it worked. Where lastname Like '____'. Thank you.