I would like to know if it is possibly to query for a portion of the NetBIOS name of a computer. My clients all have NetBIOS names that consist of a 4-character geographical site code + a 1-character system type code + a 3-digit unique identifier (001, 002, etc...). For example: The NetBIOS name 'USNYM001' might identify a computer in the US, New York site, with the 'M' representing a Mobile (laptop). What I would like to be able to do is to query for the 5th character in the NetBIOS name. The goal being to be able to identify clients that are M=laptop systems, S=server systems, D=desktop systems, etc...My SQL skills are novice at best, so there may very well be some elementary way of doing this with wildcards that I am not aware of. I thought of using 'where NetbiosName like %M%', but that won't work because it would also pull in systems with an 'M' in the first 4-characters of the name. In the old DOS days this could be done with filenames by using question marks in place of characters. Is there something similar for SQL queries?If anyone knows of a way to do this, please enlighten me. Thanks in advance for your assistance.

try this. http://tinyurl.com/ykqzo5lhttp://www.enhansoft.com/

You can use _ for 1 char replacementBL