SQL命令 [英] SQL Command
问题描述
您好,
我只是在寻找短命令,所以我可以调出以字母A-Z而不是数字开头的地址。这只是为了让我可以对这些地址进行直观的观察,不要从数字开始并将它们标记为坏并将它们从邮件合并中排除等等。然后我可以将它们追逐下次。我认为在SQL中我可以使用某些内容,例如=" something *"。我已经通过像a *这样做了很长的路要走。或者像b *通过整个alpahabet;)。工作正常我可以轻松识别它带来的错误地址PO Box也这样做。
Hello,
I am just looking for the short command so I can bring up addresses that start with a letter A-Z and not a number. This is just so I can do a visual look over these address that don''t start with a number and mark them of as bad and exclude them from mail merges etcI can then chase them up for next time. I presume there is something where in SQL I can go where like = "something * ". I have already got this working the long way by doing like "a*" or like "b*" through the whole alpahabet ;). Work ok I can easily identify the bad addresses it bring up PO Box also doing it that way.
推荐答案
您好,
我只是在寻找短命令,所以我可以调出以字母AZ开头的地址不是数字。这只是为了让我可以对这些地址进行直观的观察,不要从数字开始并将它们标记为坏并将它们从邮件合并中排除等等。然后我可以将它们追逐下次。我认为在SQL中我可以使用某些内容,例如=" something *"。我已经通过像a *这样做了很长的路要走。或者像b *通过整个alpahabet;)。工作正常我可以轻松识别它带来的错误地址PO Box也这样做。
Hello,
I am just looking for the short command so I can bring up addresses that start with a letter A-Z and not a number. This is just so I can do a visual look over these address that don''t start with a number and mark them of as bad and exclude them from mail merges etcI can then chase them up for next time. I presume there is something where in SQL I can go where like = "something * ". I have already got this working the long way by doing like "a*" or like "b*" through the whole alpahabet ;). Work ok I can easily identify the bad addresses it bring up PO Box also doing it that way.
字符应该是像这样输入
[a,b,c,d,e等]好像仍在使用它时会出现错误。
说它输入参数值atm。
should the character be entered like this
[a,b,c,d,e, etc] seem to be getting an error atm still playing with it.
its saying enter a parameter value atm.
猜猜你在寻找:
Guess you''re looking for:
这篇关于SQL命令的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!