• I think we can do it like this. Basically we just use a word boundary and a simple replace. This will find any values with numbers between 13 and 16 characters. Unless you have other long numeric values you shouldn't get too many false positives.

    string ccRegEx = @"\b\d{13,16}\b";

    string SomeValue = "this contains possible CC Nums 1234-5689-9875-5621 or so it seems.";

    SomeValue = "blah blah... 4258-1234-5678-1. Email sent blah blah...";

    Regex r = new Regex(ccRegEx);

    bool found = r.IsMatch(SomeValue.Replace("-", ""));

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/