I am fairly new to MS SQL Server 2005. I am trying to create a table where a column has the restriction of allowing alphas only.
I know how to achieve this in Oracle using String functions. But am not able to do so in MSSql.
The replace() function searches for the complete search_string to be present, as oppososed to Oracle's translate() function.
Please give me a hint if this can be achieved through inbuilt functions.
Any pointers towards using RegEx are also requested, if the same can be achieved using RegEx.
PS: I have a remote ms sql 2005 db, which I would access through java.