To be perfectly honest, even the ' isn't necessary. If it's a number, treat it like a number, not a string.
Code:
Cmd.CommandText = String.Concat( "Select identityNo from identityTab where identityTab.IdentityNo=", identifier);
-tg