Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Convert numbers in text field to numeric, eliminate text
I have a text field with records that mostly contain numbers, but some are alphanumeric, such as P234032. I want to convert the field to numeric, and just allow those fields with alphanumeric strings to be ignored, and be null.
I'm used to doing this in Microsoft Access - it just ignores those strings and they become null - how can I do this in SQL Server 2000?