I am not sure I inderstand your question. Are you asking what would the command need to be to return all entries starting with '8171'?

If so:

Select * From Area Where left(AreaCode, 4) = '8171'

>Dear All,
>
>I have records in 'Area' table, like below:
>
>AreaCode
>80
>801
>81
>817
>8171
>81715
>818
>82
>821
>
>What SQL command should I use if I want to soft search into AreaCode with value '817145779' and I want it returns '8171' (because '8171' is the most accurate pattern in the table)
>
>Please help
>
>Thanks a lot in advance
>
>Regards
>Winanjaya