Is this possible with the SELECT LIKE specification?

[chrsta]

Looking at this link: SQL SELECT LIKEWhat if you were searching for a name that starts with \[code\]H\[/code\] and ends with \[code\]dinger\[/code\]?Would I use: \[code\]SELECT NAME LIKE 'H_dinger' 'H...dinger' or 'H%dinger' ?\[/code\]I'll assume \[code\]H_dinger\[/code\] would think there is only 1 character in between, but I don't know what it is -- so I'm searching for it.\[code\]H...dinger\[/code\] isn't valid.And \[code\]H%dinger\[/code\] seems like it would check it all, but on the site, that isn't even listed?